How to remove trailing zeros from a calculated field

Question & Answer
,
2

split(field, ‘.’, 1) to get the integer part.
You can further concat the integer part with left(split(field, ‘.’, 2), 2)

1 Like