3 Replies Latest reply on Oct 25, 2018 8:19 PM by Deepak Rai

    How to set Unique number format for calculated field based on a Parameter

    Pramod Duvuri

      I created an Parameter with bunch of options that acts as an filter in my worksheet. Now I created a calculated field that will set it's value based on the Parameter selected. The paramter has options like % Growth, X Product Sales, Y Product Sales, Avg.

       

      The number formatting for this calculated field is set to Automatic and it shows 4 decimals for % Growth and 0 decimals for rest of them. Is there any option to set 2 Decimal for % Growth & Avg, 0 Decimal for Product sales?