You need to sign in to do that
Don't have an account?
lburns
Calculating Weighted average on Total Cost field
Hi...There's a standard expected revenue field already showing the weighted average based on another standard 'amount' field, but I need that to reflect on another custom field we call, 'total cost'.
I know I can create a new custom exp. revenue field, but what is the formula to do this?
If you're looking to recreate the standard Expected Revenue formula field for your custom field then you just need to create a new Formula(Currency) field with this formula:
TotalCost * Probability
All Answers
If you're looking to recreate the standard Expected Revenue formula field for your custom field then you just need to create a new Formula(Currency) field with this formula:
TotalCost * Probability
Got it..thank you!
Can I ask you one other question? Is there a rule that will show any deal in stages 1 - 5 (for example) that were moved to stages 7, 8, or 9 during a specified time frame..i.e. within the week? Using modified date, I assume.