Showing a certain value if condition is met

[#1]

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

)

[prieper]

Would use formatting in percent, thus 100% = 1. Formula may then look:

if( 

(Sum (TOTALOUTSTANDING)/Sum (TOTALPAID) >= 1)

, 1,

SUM(TOTALOUTSTANDING)/Sum (TOTALPAID)

)

HTH Peter

[#3]

This is what I have under the numbers tab

[prieper]

seem to be ok

and ...

does it work?

[#5]

it does not

[vishsaggi]

May be Try like:

if(

    Num(Sum (TOTALOUTSTANDING)/Sum (TOTALPAID) , '###0') >= '100' )

     , '100' &'%',

     Num(SUM(TOTALOUTSTANDING)/Sum (TOTALPAID) , '#,##0%')

)

Can you share a sample if still have issues?

[#7]

It says Error in Expression

[prieper · Accepted solution]

see attached

Peter

[#9]

I dont know why it isnt working for me

[prieper]

then please check the fieldnames, formula in your application same as sent to you ....

Are your fields numeric fields?

Peter