Hi,

I am working with Analysis template and i have a problem. I need to get a value with two digits after the ",".

I don't need to round the value. I tried with round(var,2) and format() but it does not work as expected.

Example:

I have: 1,2345

I need: 1,23

Can somebody help me??

Thanks and regards.

Hi Pablo,

There are 2 functions to round as well well as another function to truncate. The Trunc function is takes same inputs as Round, so usage is similar to what Roger Palmen posted. There is also a Roundfrac(number, digits) function.

Rounding down looks same as Trunc:

Rounding up is different from Trunc: