Hi Kristian
Do we take it that your formula is "Not Resolved" divided by "Number of Survey" and then divide that figure by 19%? If so why do you want to use ROUNDUP?
Also is it possible to paste a sample spreadsheet so I can take a look.
Tony
Hi,
I need help. I am trying to create a calculated field but I am having a hard time. I am working in a call center and I am currently working on the scores of my agents.
Scoring
Not Resolved/ Number of Survey
Target = 19%
=IF(TARGET<=0.19,0,ROUNDUP(??????????
What i would like to do is I want to get the specific number of Surveys for me to reach the target score.
I am someone can help me out me here.
You may reach me on my skype: kuro.chan2x
Thanks,
Kristian
Last edited by kmagpuyo; 2014-03-30 at 07:36 AM.
Hi Kristian
Do we take it that your formula is "Not Resolved" divided by "Number of Survey" and then divide that figure by 19%? If so why do you want to use ROUNDUP?
Also is it possible to paste a sample spreadsheet so I can take a look.
Tony
Try
=IF(NumResolved/NumSurvey<=19%,ROUNDUP(NumSurvey*19%,0),"")
Bookmarks