1 Reply Latest reply: Sep 21, 2010 11:45 AM by alexander.schubert RSS

    Set Analyis to replace isnull

      I have been on a crusade to eliminate if statements in expressions.

      I have the below statement that I don't know if Set would help.

      If anyone has thoughts I would appreciate it.

      Sum ([ A ]) - sum(if(IsNull([ B] ),[ C ],[ B ]))

      Basically this subtracts B from A unless B is null then is uses C