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

    rounding off number figure problem

    Joanna Seldon

      Hiya

       

      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

       

      Joeybird