You need to sign in to do that
Don't have an account?
MikeyO
Need help with a formula
Hello,
I have the following problem.
I have written the following formula, but I'm having difficulties if/when the January and/or February fields are empty
ASP= Average Selling Price
Currently I'm getting the following answer, but its not correct
January: $0.00
February: $0.00
March: $15.00
Q1 ASP: $5.00
when in reality Q1 ASP should be $15.00 since January and February were 0
Current formula for Q1 ASP = ( January_ASP__c + February_ASP__c + March_ASP__c )/if(March_ASP__c > 0, 3, if (February_ASP__c > 0, 2, 1))
Can anyone help me with this?
thank you,
Mike Oslin
Try something like this:
All Answers
Try something like this:
Thank you Stevemo, that solved the issue.
PS. You owe me a beer! ;-D and I drink THESE! http://beeradvocate.com/beer/profile/863/7971