Calculated fields

[SunTop]

Hello everyone
I have a query that contains a product, quantity, unit and price fields. All fields pick their values from an underlying table except the price which I need it to be calculated in the query. So I need to multiply the quantity by the price, but I need to use a different formula based on the value of the unit field. For example, if the unit is (Liner Metric) I need to multiply the quantity by 3.81 before multiplying it with the price, but if the unit is (Nos) then I need to multiply the quantity with the price directly. How to do that inside a query?

[CJ_London]

something like

ttlValue:[qty]*[price]*iif([unit]="linearMetric",3.81,1)

if you have lots of different units, probably better to store them in a table and link to it in your query

[Bob Fitz]

I think you need to create an expression using the IIF() function.

if the unit is (Liner Metric)

Can you explain what this means.