Calculating Percentage Differences in Pivot Table

[Taavu82]

Hello Qlik Community! 

I have a pivot table that shows counts for checks that have been cleared vs. issued by check date. In the pivot table, I have the totals turned on so I can see the total number of checks for each date. What I'm trying to do is calculate the percentage of checks in each status by check date.  So far, I have been able to determine the percent of checks still in the "Issued" status by using the expression below, but I would also like to see the percentage displayed for the "Cleared" status. Any thoughts on how I can accomplish this? 

Count({<[PAYMENT_STATUS]-= {'Cleared'}>} [PAYMENT_NUMBER])/Count(TOTAL <CHECK_DATE> {<[PAYMENT_STATUS]-= {'Issued'}>} [PAYMENT_NUMBER])

Thank you! 

[Taavu82 · Accepted solution]

No need for a response. I was able to determine that I can get what I'm looking for using the following: 

Count([PAYMENT_NUMBER])/Count(TOTAL <CHECK_DATE> [PAYMENT_NUMBER])