3 Replies Latest reply on Feb 27, 2016 11:19 AM by siplus

    How to round a currency calculation to (always) 2 decimals

    larslucidor

      I've created a script that calculates how much each member in a group will pay for a certain activity. The script creates a unique table with records that have values with none or many decimals. I wish to have maximum two decimals and that it all ends upp with either a floating window or a dialogue box telling me [sample]:

       

      "[User], this is the result:

       

      Eric pays 23.50 €

      Sammy pays 1.00 €

      Helen pays 39.56 €

      "

       

      Sofar I only managed to create a dialogue box that after use of Round returns either 2, 1 or 0 decimals. I always want 2 decimals for currencies, even if the result is exactly 1 €. It does not look professional when 23.50 €  automatically is showed as 23.5 € , the next is showed 1 € while the last is 39.56 €.

       

      I guess there should be an easy solution to this?