Calculate Multiple Fields for Extended Price

[SRessler]

I have a query in my database that sums the Count*Unit Price-Discount with the following formula.

Extended Price: CCur(Nz([Count],0)*[UnitPrice]*(1-[Discount]))

I would like to add another field called "Weight" into that formula. Basically I want to sum the total by either:

Count*Unit Price-Discount = Extended Price
or
Weight*Unit Price-Discount = Extended Price

We price items out by count and/or weight and customers may have both types of items in one of their Orders



My query line would be like this;
Product Count Weight Unit Price Discount Extended Price

[LillMcGill]

Does this work?
IIF([Count] Is Null, [Weight]*[UnitPrice]*(1-[Discount]),[Count]*[UnitPrice]*(1-[Discount]))
I would consider renaming [Count] to a word that isn't a reserved word and the name of a built-in function.

[NTC]

hmmm well I believe the correct syntax suggested should be: IIF(IsNull([Count]), etc etc

but as you state there may be both - then I guess you calc both and if one isn't there just put in a 0 or leave it null.

[SRessler]

LillMcGill

Thank you so much. It worked perfectly. You are a life saver.