In a MSSQL based report we have different columns and some of them are Total Formula calculations.

We need an extra columna whose vale is conditional to any of those Total Formula calculations. Something like

iif ( ([[Adicional]]>5.0 ), 1, 2)

In this case the result is always zero (0).

Do conditional sentences evaluate Total Formula columns correctly? It does work if it's an SQL column

How can we solve this?