Spotfire Ideas Portal
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.
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
I´m probably missing something, but couldn´t you just format each column in the cross table separately as in the attached image?
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.
What´s the use case that require you to convert a numerical column to a string?
I have had this come up with a number of customers now - can anyone suggest a workaround?
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.