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!