Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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%')