Pivot percentages for current month

[#1]

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.

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling