I have an app where I am calculating the number of courses of a product used by a client. Tables are similar to below and I am calculating Sum({<Target weight = {A}>}Quantity)/Course
Stock table
Product
Target weight - (A or B)
Course
Client Table
Client ID
Sales
Client ID
Product
Quantity
A product has a target weight set at A or B - this will generally be correct
But occasionally a product may be used in the other target weight which would result in a different course rate
I need to find a way to set the target weight for a product depending on the client
So when I select a client the product is calculated at the correct rate for the correct target weight
Hope that makes sense! Can anyone advise a way to achieve this?
