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))