Post reply

Percentage (calculated measure)

  • March 6, 2009 at 4:22 am

    #954751

    hi

    in the textbox go to properties and choose the format tab, next to format code: the is a button with ..., click it and choose percentage, your value might have to be in decimal so that its less than 100%

    hope this works

  • March 9, 2009 at 8:57 am

    #956079

    Hari, a possibly completely different solution, depending on how you're consuming the data. We use Pivot Tables for a lot of our analysis, and you can just right click on the measure in the pivot table, choose Field Settings, and use % of Column. Voila, you have % of the diagnosis.

    If that doesn't work for you, create a new calculated member like this:

    ([Diagnosis].CurrentMember, [Measures].[Claims Count])/([Diagnosis].CurrentMember.Parent, [Measures].[Claims Count])

    Then switch the format to "Percent" just as omlac suggested.

    Hope that helps,


    Rick Todd

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply