You need to sign in to do that
Don't have an account?
Nathan Hedman-Copp 2
How to calculate average daily value of an opportunity with products spanning multiple months?
I have opportunities with line items/products that have a "start date" field in one month and a "close date" field in another. If I know the total number of days where the products are active and the averaged amount for each day - how do I calculate the amount per month?
Ex. Opp A with Product B
Start Date: Jan 30
End Date: Feb 4
Total Days: 5 (2 in Jan, 3 in Feb)
Average Amount per Day: $10
How do I separate out the $20 for Jan and the $30 in Feb from the same opportunity? Ideally I'd like to run a report and see the opp amounts calculated for each month...
Ex. Opp A with Product B
Start Date: Jan 30
End Date: Feb 4
Total Days: 5 (2 in Jan, 3 in Feb)
Average Amount per Day: $10
How do I separate out the $20 for Jan and the $30 in Feb from the same opportunity? Ideally I'd like to run a report and see the opp amounts calculated for each month...
I think you should collect the amount separately by month and add the average of each month in a different field (I can't think of a better way)