 ShowAll Questionssorted byDate Posted 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 Best Answer chosen by Admin (Salesforce Developers)  SteveMo__c

Try something like this:

```( January_ASP__c + February_ASP__c + March_ASP__c ) /
(
IF( January_ASP__c > 0, 1,0) +
IF( February_ASP__c > 0, 1,0) +
IF( March_ASP__c > 0, 1,0)
)``` SteveMo__c

Try something like this:

```( January_ASP__c + February_ASP__c + March_ASP__c ) /
(
IF( January_ASP__c > 0, 1,0) +
IF( February_ASP__c > 0, 1,0) +
IF( March_ASP__c > 0, 1,0)
)```

This was selected as the best answer MikeyO

Thank you Stevemo, that solved the issue. SteveMo__c

PS.  You owe me a beer!  ;-D  and I drink THESE!  http://beeradvocate.com/beer/profile/863/7971