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
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]: