Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What I am trying to show is the percentage of fees not paid by dividing two fields, TotalOutstanding (A) and TotalPaid (A). In some cases A is greater than B so the rate is > 100.
What I want is, if the amount is greater than 100, show 100%, else show the calculated amount
This is what i have so far
if(
(Sum (TOTALOUTSTANDING)/Sum (TOTALPAID)*100 >= '100')
, '100%',
SUM(TOTALOUTSTANDING)/Sum (TOTALPAID)*100
)
i created another chart, and its showing 1. Now i justt have to change the number field. So your solution helped. Thanks!
It's not showing as a percentage