### Title

calculated value formula

### Post

my formula

If ( ClientAdress::Billing Currency = "CHF" ; Products::Wholesale 2 CHF ; Products::Wholesale 2 EUR )

does not work the way i intended it to work ... the field only shows the value of ::Products::Wholesale 2 EUR .... what am i doing wrong ..??

Billing Currency is a field in ClientAddress the other two fields are in Products

What relationship links the two tables?

In what Context does this calculation evaluate? (If this is in a script step, what layout, based on what table is current at the moment this step executes? If this is in a calculation field, what was selected from the context drop down at the top of the specify calculation dialog?