Formulas and %IF %THEN

[Mark D Eppley]

I cannot seem to get a formula to work with a %IF - %THEN statement

Formula is as follows

%IF
([[Budget]]-[[Amount]] < 0)
%THEN
[[Budget]]-[[Amount]]
%ELSE
0
%ENDIF

Results are always TRUE regardless

Thanks
Mark

[admin]

Hi Mark,

We have reproduced this and will work on a solution. In the meantime, you may be able to achieve what you want with a SQL Extra Column.

such as

CASE WHEN (budget-amount<0) THEN budget-amount ELSE 0 END
see screenshot for sample:


Let me know if that works

Best regards
Bo