Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions Data Management
Created by Guest
Created on Apr 20, 2020

RELATED IDEAS

Truncate Function in Spotfire

Currently I don't see a function to truncate the values while creating a calculated column.

Ex. Truncating 1.56 to one value after decimal which would be 1.5 (Round function would change it to 1.6)

Spotfire has a round function. But it would be great to have a truncate function that can truncate a decimal just like the TRUNC function in Excel.

  • Attach files
  • Guest
    Reply
    |     Apr 24, 2020

    Thanks for a great idea Karan. You could try to use an expression like floor(([EU_Sales]*10))/10. We should consider adding a new argument to the floor function.

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us