1 Reply Latest reply on Oct 10, 2018 8:40 PM by Naveen B

    Apply number formatting inside a calculated field based on parameter selection

    seraj alam

      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.