Hi, I have the following problem:
I'm creating a form for ordering stuff. We have different categories in different countries for maximum costs. We have a list where the limits are defined. It looks something like this:
Country | Category | Reference Price
Austria | A | 1000
Austria | B | 2000
Austria | C | 3000
Germany | A | 800
Germany | B | 1600
Italy | A | 1000
Italy | B | 1900
Italy | C | 2200
which means we have category A for a bunch of different countries but with different prices.
Now what I want to do is have a calculated value that tells the price to the person who fills it, which means I have to filter by 2 variables. How can I do that?
I tried calculated value with lookup but I can set just one filter there.