12 Replies Latest reply: Jul 2, 2015 1:26 AM by Michael Yachnik RSS

    Is Null in Set Analysis

      Help.   I am just trying to convert the If/Then SUM expression below, that works fine but is slow, to Set Analysis.   I don't know how to get the IsNull to work in Set Analysis despite searching forums.   Seems like this should be a simple modification.  


      Can anyone please assist??


      Thanks MUCH.



      Original If/Then that works fine:


      = sum(if(IsNull(TCW) and TCNB=0,TCAmt))

      Trying to convert to Set Analysis, have tried this one and many others with no luck. 

      =sum({<TCNB={0}, $(TCW=("")"} TCAmt))