Hi,
I have calculated the Percentage value for Rent and Revenue like "Rent/Revenue" in a calculated field.After adding it to Text or add in Row/Columns it is displaying wrong values/irrelevant values.
How can I show the exact values?.I have tried with Percentile and Percentage difference in Table calculations also but didn't worked.
Please Suggest.
Thanks
1 answer
Hi Sudheer,
Shouldn't your calculated field be Sum(Rent)/Sum(Revenue)?