I want to apply number formatting inside a calculated field based on value selection via a parameter. My requirement is something like below.
Case [Size Parameter] when "Thousands" then Format([number],"#,.0") when "Millions" then Format([number],"#,,.0") else format([number],"#,###.0" end
Thanks in advance.
Check this thread:
Custom Number Formatting ($K,$M)
User Filter/Parameter to Choose Rounding Format for numbers
This will help to solve your problem.
Hope this helps. Plz mark this answer as correct or helpful to close the thread
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...