HiI am trying to calculate the ask amount by probability for plans. Using the formula Ask Amount multiplied by Plan Probability is giving me totals greater than the ask amounts rather than less. How do I calculate this properly?
ThanksJess LevySan Francisco Operajlevy@sfopera.com
I think Total Plan Probability is going to wind up being .35+.35+.35… Nine times. Maybe use MAX instead?
Hi Jess,
The sum of the plan probabilities will be greater than 100%. This would probably need to be either SUM ( [Ask Amount] * [Plan Probability] ).
However, this value is already in there as a standard amount called [Goal By Probability Amount]:
Good call. MAX would work in this case since Probability is on rows.