Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have dimension Week as =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek) and expression Count as Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>}ID)
it is working in Bar chart. But I need to show another expression as % of Count as another expression. I used below one but it is not working and showing error in expression.
Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID,'#,##0.00%')
Can anyone help me how to write correct expression to show percentage of count.
Thanks.
Thanks Perfect.
try
num(Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID)/Count(all {$<Chore={'Soaps'},Flag={2}>} ID), '##%')
thank you so much for sharing this! it also works on my current problem. btw is it also possible to add the value as well as the percentage? apart from that, can I add the individual name inside the stack too? many thanks for your help