Truncate number

Can I truncate a number? I am doing an age calculation and want to truncate the result. I did a number format (0 decimal places) but that seems to round up. For age, I don’t want to round up.

Thanks, Steve

@Steve_Marquis – there might be a better way to do this, but you should be able to use the Text Extract step to solve this. You’ll want to find all text before the .. See below!

1 Like

That works. Thanks Andrew.

2 Likes

Awesome, glad to hear it!