3 Replies Latest reply on Nov 30, 2016 3:26 AM by Norbert Maijoor

# Help with Formatting one measure to display both Percentage rows and Integer Rows

My data contains a column for denominator and numerator. For some indicators, I need to simply sum the denominator to know the performance of that indicator, however for some indicators I have to divide the sum of numerator by the sum of denominator to get the percentage value.

I am hoping to create a calculated filed to display both the integer value and the percentage in one measure.

I have created this measure, however I can only format it either as a percentage or an integer...anyone know how I can have the % indicator showing a % value...and the other indicator to show as an integer value?

Any help would be very appreciated. TBWX is attached.

Remmy.

My calculation is as follows

IF ATTR([Indicator Type]) = 'IND_01' then sum([Denominator Value])

ELSE sum([Numerator Value])/sum([Denominator Value])

END

My Data looks something like this

 Indicator Type Indicator Name Client Number Date Denominator Value Numerator Value IND_01 Total Clients in the month 232323 01/01/2016 1 1 IND_01 Total Clients in the month 232348 01/01/2016 1 1 IND_01 Total Clients in the month 226661 01/01/2016 1 1 IND_01 Total Clients in the month 232079 01/01/2016 1 1 IND_01 Total Clients in the month 232104 01/01/2016 1 1 IND_01 Total Clients in the month 232129 01/01/2016 1 1 IND_01 Total Clients in the month 232154 01/01/2016 1 1 IND_01 Total Clients in the month 232179 01/01/2016 1 1 IND_01 Total Clients in the month 226492 01/01/2016 1 1 IND_01 Total Clients in the month 231910 01/01/2016 1 1 IND_03 % Clients with an order 232323 01/01/2016 1 0 IND_03 % Clients with an order 232348 01/01/2016 1 0 IND_03 % Clients with an order 226661 01/01/2016 1 0 IND_03 % Clients with an order 232079 01/01/2016 1 0 IND_03 % Clients with an order 232104 01/01/2016 1 0 IND_03 % Clients with an order 232129 01/01/2016 1 1 IND_03 % Clients with an order 232154 01/01/2016 1 1 IND_03 % Clients with an order 232179 01/01/2016 1 1 IND_03 % Clients with an order 226492 01/01/2016 1 1 IND_03 % Clients with an order 231910 01/01/2016 1 1
• ###### 1. Re: Help with Formatting one measure to display both Percentage rows and Integer Rows

Hi Remmy,

Find my approach as reference below and stored in attached workbook version 10.1

• ###### 2. Re: Help with Formatting one measure to display both Percentage rows and Integer Rows

Cheers Norbert....Worked a treat.

Cant thank you enough.

• ###### 3. Re: Help with Formatting one measure to display both Percentage rows and Integer Rows

Remmy,

You are welcome. Thanks for the "awards". Appreciated!:)