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.
