Crosstable- Calculated Column/Custom Expression- Percentage Totals from Aggregated Columns

I am attempting to create a table that shows the Renewal Rate of a multi-family apartment complex within a Cross Table. Below is the table that I have so far which shows whether the tenant renewed their lease [Renewed Y/N] broken out by the month there lease was set to expire "Month[Current Lease Expiration Date]". I want to create a third column titled "Renewal Rate" that takes the sum of "Yes" responses and divides it by the sum of the "Yes" and "No" responses shown in the table. Attempting to create it through a Custom Expression but am unable to come up with the code that shows the proper result. Much appreciate if someone could help me with the proper Custom Expression code or another mode to get the result I'm attempting to show. 

 

Attachments

AttachmentSize
Image icon renewal_rate.png14.94 KB

(1) Answer

Login