Jump to content
We've recently updated our Privacy Statement, available here. ×

No truncate function

Todd Crites

Recommended Posts

  • 1 year later...

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...