Rounding of numbers and Currency Symbol

  • Hello i’m wondering if their is a way in which numbers can be rounded up to say 1.17 instead of 1.1700027648473 for instance also i would like to add the currency symbol in calculated field so total would be for instance ￡1.17 instead of this 1.1700027648473

    Please Help need a solution.

    Thanks

Viewing 4 replies - 1 through 4 (of 4 total)

  • Curious/wondering too.

    Yeap. Also need this.

    Ok so I finally figured it out by myself, I’m a big boy. Look at me, wearing my big boy pants

    You go to the ‘settings calculator’ tab and tick the “Enable format total value” box. Then down the bottom there’s ‘Number of Decimals’.

    See Screenshot.

    Was struggling with this also. But if somebody interested you can use in your formulas Math functions of JS.
    Example if you need to achieve this one (last two letters is floored):
    13452 => 13400
    12999 => 12900
    13228 => 13200

    use this:

    [calculated calculated-478 “Math.floor( (radio_custom-881 * radio_custom-639 + number-456 ) / 100 ) * 100”]

    Change the fields according to yours.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Rounding of numbers and Currency Symbol’ is closed to new replies.