7 Replies Latest reply: Dec 4, 2016 5:30 AM by PAUL YEO RSS

    How to make -125.8% display as +100% ?

    PAUL YEO

      Hi All

       

      I have a expression.

       

       

      (

       

      sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(YearStart(Today())))<=$(=num(Today()))"}>} Amount*-1/1000)

      -

      sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount*-1/1000)

      )

      /

      sum({$<nET_PROFIT={'nET_PROFIT'}, date={">=$(=num(AddYears(YearStart(Today()), -1)))<=$(=num(AddYears(Today(), -1)))"}>} Amount*-1/1000)

       

      Now mu issue is when 2015 net profit amount -ve and 2016 net profit amount +ve , it display -ve % , which is wrong , i like to make it display 100%.

       

      Hope some one can advise me.

       

      Paul