17 Replies Latest reply: Aug 7, 2018 10:06 AM by manoj kumar RSS

    transform field to get sum of values and absolute values

    Angel Tomov

      Hello guys,


      I am experiencing a little confusion, with certain fields.


      In the attached excel file, you will find the test transactional data of a company I am working with.


      I am bashing my head against transforming the field SalePrice, from this format "23,45 leva." to 23,45 . Leva is the currency of my country.


      So Far I have tried with 
      KeepChar(SalePrice ,'.,01234567890'), but this doesn't work correctly, it doesnt turn all values and it points to a . in the end. 


      I also have a problem with converting the Quantity field from - to +, I have tried with :
      Fabs(Quantity), but this returns 0 value ..



      How can I transform the SalePrice field, so I only get the Price in an acceptable format with the cents behind the coma. 


      Thanks dear Qlikers !