Please help first timer with calculation

[Rangoon]

I have been using "repeating fields" for the following calc. I am now switching to "Line Items" and my problem is this. The calc works fine for individual item pricing, but I need it to give me the Lb. Price for each item based upon the entire pounds of the order, not just the one line item. (each line item also has an order number unique to each order". Your help would be very appreciated as I'm a little over my head here.

Pound Sell Price

If(CasesOrderedSum = 0, TextToNum(""), If(Extend(Sales Detail::OrderType) = "Direct",

If(NetWtCalcSum <= Lb1 , SellLbCalc1, If(NetWtCalcSum >= Lb1 + 1 and

NetWtCalcSum <= Lb2 , SellLbCalc2, If(NetWtCalcSum >= Lb2 + 1 and

NetWtCalcSum <= Lb3 , SellLbCalc3, If(NetWtCalcSum >= Lb3 + 1 and

NetWtCalcSum <= Lb4 , SellLbCalc4, If(NetWtCalcSum >= Lb4 + 1 and

NetWtCalcSum <= Lb5 , SellLbCalc5, "Weight not Found!"))))),

If(Extend(Sales Detail::OrderType) = "FOB", PriceLbFOB,If(Extend(Sales Detail::OrderType) = "Warehouse" and PriceLbWhse = 0,

SellLbCalc1,PriceLbWhse))))

Thank you,

Harry

[FMPierce]

I believe that you should be using semi-colins instead of commas.

Hope it helps.

[Christine Sephton]

If you are no longer using repeating fields, you no longer need the extend function.

Christine

[comment]

I need it to give me the Lb. Price for each item based upon the entire pounds of the order,

Please explain the logic behind the calculation (your formula is incomprehensible, because we don't know what's what).

[LaRetta]

Well, we are thorough even though we are 11 years slow in our response. :yep:

[comment]

Oh.

:bang:

[bcooney]

LOL!

@FMPierce - your enthusiasm for FM calcs is wonderful, but please pay attention to the date of the original post!