How can I format a number differently by row in the Render tool? Specifically, for example, how can I show decimal places for, say, a ratio value when other values are whole numbers. TIA.
Solved! Go to Solution.
@MeanLeanDean
It seems that the Decimal Place by default is 0 for columns.
We need to change it if want different.
Building on Qiu's answer. If you only want specific rows of the column to have decimal places, you can use a combination of a helper column and formula rule.
This is a simplistic example but it works.
I create a Boolean column and set it to true for items I want to save the decimal for.
The rule just looks for the Boolean being true to apply. Just remove the helper from the output so you dont see it anymore.
Your other option is to convert the columns to string for output instead, but if the goal is to output to excel, it will take issue with numbers formatted as text.
Here is the same data set output but formatted as string before reaching the table tool
Thanks to both of you!