Goal Attainment Formula

[cvgreports]

I have the following and need help creating a formula to give me the % of goal attainment against month expired.

Monthly (22 work days) Goal is 100 sales
50% of month elapsed (11 days)
we have 30 sales so far

I'm stumped on how to create a formula to calculate % of the goal attained against month expired.


Thanks in advance

 

[pgc01]

Hi

Not I understood correctly but try:

=30/(11/22*100)

The logic: in 11 days he/she should have 50 sales. Since there are only 30 sales, only 60% of the goal was met so far.

Is this the logic?

 

[cvgreports]

pgc01, thank you so much....that's exactly the % I was looking for.