calculated value

Issue #948 resolved
Inessa Chernoguz created an issue

I am using mathematical calculation. I want to receive answer includes only 2 digits after “.”… I am receiving something like 73.3566777777, I want to receive 73.36 (for this example). I am using: ^{Requests In Progress}+{Total Travel Cost (in USD)} I didn’t find any function that can do it. Can you, please help?

Comments (2)

  1. Fidel Castro Armario repo owner

    Hi @cinessa,

    In order to limit any math calculation to 2 decimal digits you should use the following expression:

    round(value * 100) / 100
    

    replacing value with the formula for the calculated value.

    In your particular case you should use the following expression:

    round((^{aaaaa} + {bbbbb}) * 100) / 100
    

    replacing aaaaa with field code for "Requests In Progress", and bbbbb with field code for "Total Travel Cost (in USD)".

  2. Log in to comment