Can you use this formula.
This Calculation for W3 Field.
IF Data_Type = 'Percent' THEN STR(round(([W3]),2)) + "%" ELSEIF
Data_Type = 'Decimal' THEN STR(round(([W3]),2))
Can you tell me how to get this done on the GOAL field since it is already a string?
And your calculation doesn't seem to work. For example: If I just create a dummy calculated field like: STR(ROUND(1,2)) so that output should be 1.00 right? But the output is just 1