I have a situation about a formula I created to pull the last sales price of our inventory which works okay, but what I could not formulate is how to make this formula pull the next sales price if the last one equals zero.

 

Below is the formula thats been used;

 

if {AR_InvoiceHistoryHeader.InvoiceDate}=Maximum ({AR_InvoiceHistoryHeader.InvoiceDate},({@Remove "-G"})) then

formula = {AR_InvoiceHistoryDetail.UnitPrice}
else

formula = 0
end if

 

Thanks in advance.

 

CRW

 

Again Thanks.

 

CRW2