14 Replies Latest reply: Dec 23, 2015 10:54 AM by Sangram Reddy RSS

    If statement that for some reason doesn't work

    jhonatan ben ami

      Hey Everyone ,

      I am trying to run the following IF statement :

      IF(EnCurrency='NIS',Num(sum( {$< TRANS_TYPE = {N}>}  NIS_TRANS_TOTPRICE  )* -1,

      IF(EnCurrency='$',Num(sum( {$< TRANS_TYPE = {N}>}  DOLLAR_TRANS_TOTPRICE )* -1,

      IF(EnCurrency='EUR',Num(sum(  {$< TRANS_TYPE = {N}>}  CURRENCY_TRANS_TOTPRICE)* -1 ))))  ;

       

      EnCurrency= CURRENCY

       

      for some reason this If statment doesn't