Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table showing top 10 values by a dimension for the current month. This works fine :
sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)
I want to then work out the % of the current month for each of the lines, trying to use this but it only returns 100% ? :
sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)/sum({$<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)
Any idea where I am going wrong?
Hi,
Try below expression:
sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)/sum(Total {$<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)
HTH
sushil
Hi,
Try below expression:
sum({<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)/sum(Total {$<Year={$(=year(today()))},MonthNum={'$(=upper(Month(today())-1))'}>}Value)
HTH
sushil
Of course, DOH!!! Many thanks!