The Grouping makes sense when just looking at transforming the values of a single column, but I think the question here is how can we in building a formula evaluate a column to see if a value is null. For example the formula below is checking a column to see if a value is null, if it is not a calculation takes place, if it is null text is entered in the new calculated field.

If([TestColumn] != {null}, Sum([Sales]+[SalesTax]), 'No Sale')

As of right now the only way I can write this formula to work as intended is to do it as shown below

If(Nvl([TestColumn],0) != 0, Sum([Sales]+[SalesTax]), 'No Sale')

I know the Nvl function can do the check for the null in this calculation, but is there a specific syntax to be used to make the first formula work? If not, working forward with the Nvl is acceptable. It would just help to streamline the formulas in a Nested If scenario.

Thanks