No truncate function?

Is there really no truncate function in Spotfire?  I'm looking to take decimals like 76.996 and truncate to 76.9 instead of rounding to 77.0.  How would I go about doing this?  I would use "Trunc(76.996,1)" in Excel and get 76.9.  

Any suggestions?


Unfortunately no, no response here and I didn't find anything otherwise.  Sorry about that.

todd.crites - Apr 20, 2020 - 10:15am

have you found a solution to do the trunc and not the round?

Grazia - Apr 20, 2020 - 9:29am
+ Add a Comment

(2) Answers