Forum Discussion

AmyGosz1's avatar
AmyGosz1
Qrew Cadet
2 months ago

Show numeric formula total as percent

I am having trouble showing a formula sum as ‘percent’.  The following formula returns the value as 73, which is correct. However, I need it to display as 73%.

Round(

       (

        ([Overall Satisfaction])*0.15+([Trust])*0.2+([Feeling Valued])*0.2+([Communication Quality])*0.1+([Personalization])*0.1+([Impact Perception])*0.15+([NPS Score])*0.1)*10

       )

If I change the field attribute ‘Display as’ to Percent, then it shows as 7300%. If I add to the formula to divide it by 100 at the end, then it shows the result as 100%.

Round(

       ((

        ([Overall Satisfaction])*0.15+([Trust])*0.2+([Feeling Valued])*0.2+([Communication Quality])*0.1+([Personalization])*0.1+([Impact Perception])*0.15+([NPS Score])*0.1)*10)/100

       )

Where am I going wrong with my syntax on getting this to work? I have tried as both Numeric-Formula and Numeric-Percent field types.

3 Replies

  • Try this

    Round(

      [Overall Satisfaction] *0.15

    + [Trust] * 0.2

    + [Feeling Valued] * 0.2

    + [Communication Quality] * 0.1

    + [Personalization] * 0.1

    + [Impact Perception] * 0.15

    + [NPS Score] * 0.1)/100),0.01)

     

         

  • Hi Mark....thank you for the quick reply! The only change I needed to make was dividing it by 10 instead of 100. It's perfect now.

    • MarkShnier's avatar
      MarkShnier
      Qrew Cadet

      OK great, ya sometimes with those percents I find I have to fiddle with what to divide by.!