3 Replies Latest reply: Jan 5, 2018 11:57 AM by Sunny Talwar RSS

    Exclude negative and positive values from expression

    Uriel Gonzalez

      Hi,

       

      I have the expression to calculate difference.

      But i only want to show negative difference (Value) also excluding positives values in the calculation. and then vice versa (show +ve, exclude -ve)

       

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


      How do i do this?

       

      Any help please?


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

       

      Thank you!