5 Replies Latest reply: Oct 8, 2010 12:43 PM by Karl Pover RSS

    Set Analysis with Greater than and Less than

    Thom Mumaw

      Thought I had the syntax down, but I guess I don't. Need a little help.

      Thanks Thom

       

      sum({<{"len[Cancel Reason] > 0, [Cancel Reason <>{14}"}>} [Non Accepted Sales])

       

      I want to sum Non Accepted Sales if the length of my cancel reason is greater than 0 and cancel reason not equal to 14.