3 Replies Latest reply: Sep 6, 2016 8:15 PM by Sunny Talwar RSS

    I have 2 script amount ,How to sum these 2 script amount ?

    Yeo Poh sai

      Hi All

       

      May i know how to sum up the below script ?

       

      if(right(@162:174T,1)='-', '-' & left(@162:174T, len(@162:174T)-1),@162:174T) as ab18,

       

       

      if(right(@179:191T,1)='-', '-' & left(@179:191T, len(@179:191T)-1),@179:191T) as ab21,

       

      I try below , it does not work :-

       

      sum(
      if(right(@162:174T,1)='-', '-' & left(@162:174T, len(@162:174T)-1),@162:174T))
      +
      sum(
      if(right(@179:191T,1)='-', '-' & left(@179:191T, len(@179:191T)-1),@179:191T))
      as ab1821,