Tableau Formatting Numbers in calculated field

1
votes

I have a calculate field named Table Measure, and it contains Percent and Numbers. How can I format the % with 1 decimal place and the number of records with comma and zero decimal place? I tried to use FORMAT([% of Composite VOC]),"#.0%") it gave me an error.

    IF [Toggle] = 1 THEN ([% of Sale 1]) ELSEIF [Toggle] = 2 THEN [Total of
 Profit] ELSEIF [Toggle] = 3 THEN [% of Discount] ELSEIF [Toggle] = 4 THEN % of
 Commission ] ELSEIF [Toggle] = 5 THEN [Number of Records] END) END
1
tableau-api
what is the error? – Siva
are you using R or Python for format function? – Siva

1 Answers

0
votes

Right click on the calculation "Table Measure" -> Select "Default Properties" -> "Number Format" -> "Percentage"...update to 1 decimal.