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