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:
This will help to solve your problem.
Hope this helps. Plz mark this answer as correct or helpful to close the thread