Holding percentage from the total

[nevilledhamsiri]

Dear Friends,

As per the above, If I am to get the holding percentage of individual items from the total, the simple formula such as below works but if the measure is a s results of a multiple criterians like below, how this needs to be applied to get the expected out put. The measure looks like below

SUM({<PRD_CODE={'MC','TC','HH','PP','M4'},ACCOUNT_CODE={'7156','5526','2255','4525'}>}C_BALANCE)

If the above is the measure, how this is combined in to sum (Total) function.

SUM(SUM({<PRD_CODE={'MC','TC','HH','PP','M4'},ACCOUNT_CODE={'7156','5526','2255','4525'}>}C_BALANCE))/SUM(TOTAL SUM({<PRD_CODE={'MC','TC','HH','PP','M4'},ACCOUNT_CODE={'7156','5526','2255','4525'}>}C_BALANCE))

The above function seems to have a syntax error.

Thanks

Neville

[vishsaggi · Accepted solution]

Try this?

SUM({<PRD_CODE={'MC','TC','HH','PP','M4'},ACCOUNT_CODE={'7156','5526','2255','4525'}>}C_BALANCE)

/

SUM(TOTAL {<PRD_CODE={'MC','TC','HH','PP','M4'},ACCOUNT_CODE={'7156','5526','2255','4525'}>}C_BALANCE)

[nevilledhamsiri]

Thanks Vishvarath,

This is alright

Neville