8 Replies Latest reply: Mar 16, 2011 6:22 AM by akmal786 RSS

    check this statement it is not working (Aoiding null values)

    akmal786

       

       

      sum

       

      (if(trim(IS_MIN=1 and IS_MIN<>11 and IS_MIN <>0), (if(cm=null() , [CM],0))+ (if(OTHER_CM=null() , [OTHER_CM],0)), null())))