Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
I am trying to get a percentage of the total row. Take for instance the top row has 300 sent to agent, i want to know what the percentage of 138,889 in total calls this is. Currently, my expression only states sent to agent/all calls. I tried to plug the sent to agent/sum(Total([All Calls]) to no avail. Any help would greatly be appreciated.
Thank you,
Kristy
What do you get when you make sum(Total CallCounter) as an expression?
Try to replace the [Sent to Agent] by the original sum expression too
Kristy,
What is your expression to get the 138 889?
If [All Calls] is a field in your model, it should work... What happen when you create only this as an expression (sum TOTAL [All Calls] )
All calls is calculated by counting the CallCounter that I have added into the script. Should my expression be [Sent to agent]/sum(Total CallCounter)?
Thanks
Yes,
You can not use the total modifier associated with another expression in the object
Regards,
Erich
When I use that expression, the chart comes back up blank.
[Sent to agent]/sum(Total CallCounter)
Now, Call Counter is a field I added in the script. Would that be why? It's not an original field.
What do you get when you make sum(Total CallCounter) as an expression?
Try to replace the [Sent to Agent] by the original sum expression too
Thank you!!! Perfect!!!