calculate sum from list of valuelists

[concrete]

I have a list of options an order can have

each option is a value list with multiple options. (for example: option 1, option 2, option 3)

now i need to make a total of this order (knowing that option 1 is ?40, option 2 is ?20, ... , but the name of the option doesn't include the price).

So i think i need a calculation with "if" "then" commands...

hope this is clear

[Lee Smith]

How many Options are there?

If it is only 3, then you can hard code them into a case statement. I suspect however, that you have more than three, or you will have in the future.

For the three you mention, the case would look like this:

Case(YourValueList = "option 1", "40.00", YourValueList = "option 2","60.00", YourValueList = "option 3", "80.00")

HTH

Lee