Calculating percentage area wise

stephenedberkg — Wed, 07 Oct 2015 08:12:09 GMT

i want to calculate the are wise percentage

=num( (sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Area={'Dubai'} ,TransactionType={'I'}>}#sales)

sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Area={'Dubai'},TransactionType={'C'}>}#sales))

(sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType={'I'}>}TOTAL #sales)

sum( {<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},TransactionType={'C'}>}TOTAL #sales)),'0%')

its working fine but when i click the area dubai its show the 100% but my dubai sales is 54%

how can i change the expressions?

Re: Calculating percentage area wise

pokassov — Wed, 07 Oct 2015 08:14:50 GMT

Hi!

Could you try this:

=num( (sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Area={'Dubai'} ,TransactionType={'I'}>}#sales)

sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Area={'Dubai'},TransactionType={'C'}>}#sales))

(sum({<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Area=,TransactionType={'I'}>}TOTAL #sales)

sum( {<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))},Area=, TransactionType={'C'}>}TOTAL #sales)),'0%')