9 Replies Latest reply: Dec 31, 2015 5:44 AM by jhonatan ben ami RSS

    if condition that doesn't work

    jhonatan ben ami

      hey everyone i am trying to set an if condition but for some reason it dosen't work:

       

      if sum({$<YEAR={'$(=max(YEAR-1))'}>}RIV_QUANT)>0 and

      sum({$<YEAR={'$(=max(YEAR-1))'}>}NIS_TOTPRICE)>0 and

      (sum ({$<Year={'YEAR'}>}RIV_QUANT))<1 and

      (sum ({$<Year={'YEAR'}>}NIS_TOTPRICE))<1,(sum ({$<Year={'YEAR'}>}NIS_TOTPRICE))

       

       

      RIV_QUANT=quantatiy

      NIS_TOTPRICE=sales