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?
Good call. MAX would work in this case since Probability is on rows.