I m trying to attach (% ) symbol to expression value. but it converts expression to string . please suggest
(countD(if [MonthYear]>=[start date ] and [MonthYear] <= [End date ]
[grp]= 1 or [grp]= 2
END) / total(countD(if [indicator]='Y' then [user id] END))*100)
Take out the *100 from the end of the calculation so that it is returning a decimal value. Then, right-click the measure and select Default Properties>Number Format and set it to Percentage.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...