How to change formula with a specific selection?

[#1]

When I have one selection selected eg. a product I want to change the expression used so that it uses another variabel in that expression.

Eg:

LGD*K when product x is selected

LGD*K2 when product y is selected.

Or if there is another smarter way to go about this issue ?

[#2]

Hi,

try with "Getfieldselections(Field)" to know which product you select.

For instance:

IF(Getfieldselections(Field) = 'X', LGD*K)

Hope it helps

Giampiero

[jagan]

Hi,

Try this

=If(Only(FieldName) = 'x', LGD*K,  If(Only(FieldName) = 'y', LGD*K2, DefaultExpression))

Hope this helps you.

Regards,

Jagan.