If Statement - Invalid type in operator

[julianhoetzel]

Hi everyone,

could someone explain why there is an invalid type in operator in my if statement? 

Thank you in advance.

[Emil_Kos]

Hi @julianhoetzel,

It looks that % of total payables aging is in string format.

Change it to a number and it should work(of course remove to string formula).

If this helped please mark my post as a solution!

[pedrodrfaria]

The field % of total Payables Aging is a string value thus not allowing you to do numeric comparisons (greater than in this case). You must change the type to double or use the tonumber() to temporarily fix this for this expression you have written out.

[Qiu]

@julianhoetzel 
I count 3 locations that can be improved.
See the markup below.