3 Replies Latest reply: Apr 28, 2015 3:22 AM by Joanna Seldon RSS

    rounding off number figure problem

    Joanna Seldon



      I need to stop a sum from rounding off a number


      e.g the correct answer should show 5.5...but I get 6


      can you please show me how I can edit this code below to stop this


      num( sum(Target), $(= chr(39) & $(=$(vFormat)) & chr(39)))




      note: this part is needed to convert number to percentage (= chr(39) & $(=$(vFormat)) & chr(39)))


      Kind Regards