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?