8 Replies Latest reply: Oct 29, 2015 3:36 AM by kushal chawda RSS

    how to write a Sum Set analysis isNull condition

    Jim Chan

      Hi all,

       

      I have a set analysis to write something like this.  sum({<menu_type={'M'},isnull(price101)>}sales)

      i wanted to write something sum out , if my price101 has Null or zero value.

       

      I hit error when i wrote in this way - sum({<menu_type={'M'},isnull(price101)>}sales)

       

       

      Rgds,

       

      Jim