Hello all,
is there a formula where you can round to any decimal places? I would like to round the formula part in the square box to three decimal places, for example 0.123.
image1138107 12 KB
But the total result should be calculated to any number of decimal places.
Best regards
+2Hi Kevin,
unfortunately it ROUND() does not work like in SQL, but you can get the first 3 decimal numbers by doing calculations like
(NUMBER-FLOOR(NUMBER)) and getting the 1st,2nd, and 3rd decimal by multiplying by 10,100,1000 respectively.
You can also create a custom formula that fits your needs in the format config of each KPI. Just make sure to use the correct syntax.
Best
Kevin
+2Hello Kevin,
as I understood, it is not the final result that needs to be rounded to 3 decimals, but part of the calculation. Hence, changing the formatting wont solve the issue.
As an alternative, you can add another column in SQL being ROUND(column,3) and use it for the calculation.
Best,
Gabriel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
