Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm working on a Pivot table and need to show percentages through an expression. The below formula works perfectly to achieve what I wish when applying it to the dataset in my pivot table.
Count(ID)/ Count (TOTAL ID)
I have another column that totals data for the previous month using the following formula in an expression:
sum(InMonth(ComplaintDate,TODAY(),-1))*-1
I'd like to calculate the percentage for the previous month similar to the way I did it above, but when I create the below expression, it doesn't work.
(sum(InMonth(ComplaintDate,TODAY(),-1))*-1) / (sum(TOTAL InMonth(ComplaintDate,TODAY(),-1))*-1 )
What am I missing?
Thanks in advance for any help you can provide.
Please read these two documents: