We’ve added NullIf function to TeamDesk formula language.
NullIf(A, B) does check if A equals to B and evaluates to NULL or to A otherwise.
Its primary usage is to simplify the check for divisor equals to zero.
Currently to cope with division by zero error we write something line: If(B<>0, A/B, null)
TeamDesk evaluates each occurrence of B separately, and B is evaluated twice. There is nothing wrong when B is "normal" column, but in case B is formula or summary column, it could cause performance hit.
New function allows to rewrite the division as: A/NullIf(B, 0) evaluating B once.
