NullIf function

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.

Tweet about this on TwitterShare on Facebook0Share on Google+0