No truncate function

[Todd Crites]

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

[Grazia Palmisano]

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

[Todd Crites]

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

[Shashank Gurnalkar]

As a workaround, can you try this and let me know if this helps

1. Convert the formatting of the column from the default 2 decimals to 3 decimals from Column Properties >> Select the column >> Formatting tab >> Number >> Under Decimals, select 3 from the drop-down and click OK.

2. Create a calculated column with the following expression.

Integer(Substring(String(Integer([Data] * 1000)),1,Len(String(Integer([Data] * 1000))) - 2)) / 103. Change the formatting of this calculated column to 1 decimal place. It will look something like this.

[Grazia Palmisano]

The formatting property execute the round of value

[Todd Crites]

Thank you, this does give the desired result.  I appreciate you sharing this.

 

I hope Tibco understands how silly it is to have to go to this length to 'truncate' when competitive tools have simple TRUNC() functions.  It's probably not high on their radar, but small things like this do make a difference in the eyes of the users.