Hi There

I’m hoping someone can help me here.  I’m trying to setup a formula to calculate the actual unit price when a lot price is given.  Someone suggested to use a subreport to lookup if there is a “lot price” in the sequence but that’s not working….any suggestions

                                    QTY                Unit price         Actual unit price

ALB1                           4                      6.74                             4.58    

ALB2                           10                    0.98                             0.67

Lot price                      1                      25.00

I'm not quite sure what that it is.  The data is held in a ddf file and it just pulls in these fields of information (Inventory, Qty, Price).  Then I tried to set up the formula's so that it would "lookup" to see if "lot price" was in the inventory listing, if so it was to display the unit price. (which it does) but then to calculate the actual unit price it is working into the formula the "lookup" the lot price formula (because I need this number to do the calculation) and is returning 0.00 for the items except the actual lot price line item...does that help?

That's correct.  The lot price is an inventory item the same as the other two items.  I can't post in a picture of what the data looks like but this is how it reads:

        QTY                                       Unit   Extended   Total              Equals

ALB1  4          =IF(A1="Lot Price",D1,0)    6.74     =B1*D1       =(E1/$E$5)*$C$5     =F1/B1  ALB2 10        =IF(A2="Lot Price",D2,0)    0.98      =B2*D2       =(E2/$E$5)*$C$5     =F2/B2

Lot Price 1    =IF(A3="Lot Price",D3,0)    25         =B3*D3       =(E3/$E$5)*$C$5     =F3/B3