Hello, does anybody know how to create an IF based formula. The structure: Product Type (Dropdown Field) Amount (Currency Field) Value A (Currency Field) Value B (Currency Field) Value C (Currency Field) Value D (Currency Field) IF Product Type = Product A THEN Amount = Value A * Value B IF Product Type = Product B THEN Amount = Value C * Value D Kindly advise, thank you.

Hi Jean Pierre Rojas The formula may looks like that: ifElse(equal($product_type,"Product A"),multiply($value_a,$value_b),ifElse(equal($product_type,"Product B"),multiply($value_c,$value_d),0)) Obviously you need to replace the fields I added in the formula by the correct ones. Regards

How To Create an IFS Formula based on X?

Jean Pierre Rojas over 3 years ago

Hello, does anybody know how to create an IF based formula.

The structure:

Product Type (Dropdown Field)
Amount (Currency Field)
Value A (Currency Field)
Value B (Currency Field)
Value C (Currency Field)
Value D (Currency Field)

IF Product Type = Product A

THEN Amount = Value A * Value B

IF Product Type = Product B

THEN Amount = Value C * Value D

Kindly advise, thank you.

Parents

0 Missy Brooks over 3 years ago

Jean Pierre Rojas might I ask how or where you apply this? Would this be usuable within the catalog for quoting? I know there are more oob options we are not yet using - and need to be. This looks valuable.

Thanks for any input you might be willing to lend

Missy B.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Missy Brooks over 3 years ago

Jean Pierre Rojas might I ask how or where you apply this? Would this be usuable within the catalog for quoting? I know there are more oob options we are not yet using - and need to be. This looks valuable.

Thanks for any input you might be willing to lend

Missy B.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data