I have two columns of data, calls made and sales booked, I wanted to produce a success rate column next to them.

So far i have the rate and calculation correct, but i would like to add the percentage symbol to the final figure.

ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2)

How can i rewrite the formula to acheive this?

GCavin
(GC)
January 9, 2023, 1:06pm
#2
You can either add

`&"%"`

at the end of your formula

or use the summary field: the same way you add a currency sign, you can add a % sign (this applies to the whole column, not just the summary as you can see in this screenshot):

GC:

&“%”

Thanks for the help. That doesn#t seem to have helped yet. I forgot to add that this is a subitem column.

Would this be the correct formula?

ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2)&“%”

GCavin
(GC)
January 10, 2023, 11:17am
#4
Try enclosing the calc with parentheses before adding the ampersand and the % sign:

```
(ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2))&"%"
```

The other, maybe better, option is:

```
TEXT(ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2),"0%")
```

GC:

`TEXT(ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2),"0%")`

Thank you so much for you advice. We are a little closer.
TEXT(ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2),“0%”)

this produces

and this one
(ROUND(MULTIPLY(DIVIDE({Booked},{Calls Attempted}),100),2))&“%”
produces

correct for the percentage, is there a way to remove the error when no data? Thank you again for everyones help.

GCavin
(GC)
January 10, 2023, 11:42am
#6
Adjust your calc in the first case. Seems you need to remove the Multiply by 100.

1 Like