3 Replies Latest reply: Jan 8, 2018 7:08 AM by omar bensalem RSS

    How to separate -ve and +ve values in straight table

    Uriel Gonzalez

      I did a expresion to give me the difference in percentage between 2 same values to see how much it change. i want to visualize positive percentage values in one table and negative in the other one.


      The expression that im using is this:


      Num(1 - Sum({<TimeStamp={'Old'}>}Amount) / Sum({<TimeStamp={'New'}>}Amount), '#,###.#0%')


      Any ideas?.