I need help on this issue:
Using a product Drop Down field,
how can we get the Value data for calculation purpose (the Value data shown when choosing «show values»).
In fact I need to make another field with the Value multiply by the Price to get a Total amount (in this case the Value represent a quantity. The Unit cost is changing according the quantity)
TOTAL field data would be VALUE * PRICE
How can I create this field with this formula ?
Thank you for your help