Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Created by Guest
Created on Nov 6, 2017

Additional string function where you are able to change the rounding settings

Belongs to the article https://community.tibco.com/questions/rounding-issue-string-function.

If you use a numeric column and convert the result to a string column, there are always only 2 decimals shown. For calculating P values you´ll need 4 decimal point. For that we should have an additional string conversion that allows to select the decimal points.

  • Attach files
  • Guest
    Reply
    |
    Apr 23, 2019

    Attached is the screenshot of use case where each column has number and percentage formatting and needs to be converted to String in order to get the required format. With current cross table design, Amount, Plan cell values column could be formatted but specific row values could not be formatted so there is a need to use String function which will format the values for specific rows in percentage format with few decimals. Hence there is a need for flexible String function with formatting option.

    https://community.tibco.com/questions/how-add-calculated-column-and-rows-cross-table

  • Admin
    Tobias Lehtipalo
    Reply
    |
    May 16, 2018

    I´m probably missing something, but couldn´t you just format each column in the cross table separately as in the attached image? 

  • Guest
    Reply
    |
    May 14, 2018

    The case is when using a crosstab vis but having varying formats in the crosstab. i.e. imagine a 4 box square where one value is a currency, another a whole number another a percentage and the final one a unit value to 4 decimal places. To get the formatting to work at this level means you have to turn the values into strings then format them afterwards.

  • Admin
    Tobias Lehtipalo
    Reply
    |
    May 11, 2018

    What´s the use case that require you to convert a numerical column to a string? 

  • Guest
    Reply
    |
    May 11, 2018

    I have had this come up with a number of customers now - can anyone suggest a workaround?

  • Guest
    Reply
    |
    Nov 7, 2017

    A more flexible version would be nice. Why not just implement a c-type sprintf function? This should give all the flexibility required and should be easy to implement as sprintf is a standard c library function... It would also be great to have this as a formatting option.