I am trying to round off 1.6 expected value is 2 but value I am getting is ‘round1.6’. I am getting same bug for floor function also.

Maybe try to put the whole function into brackets like (round(1.6))

2 Likes

Worked for (round(1.6))

But not working for (round([HOUR_0_11_Z]/10))

Expected value is 0 or 1 but getting

I guess it is because [HOUR_0_11_Z] is a text value (meant to add leading zero).

For calculations like that use the tag without _Z.

Btw., if you wanted to isolate the first digit of hours, I think floor function would work better.

2 Likes

Without _Z worked thanks