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
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!
That works. Thanks Andrew.
Awesome, glad to hear it!