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 4 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 André Lopes over 4 years ago

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

André Lopes
Lampada Global

Skype: andre.lampada

Reply

0 André Lopes over 4 years ago

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

André Lopes
Lampada Global

Skype: andre.lampada

Children

0 Jean Pierre Rojas over 4 years ago in reply to André Lopes

Thank you for the suggestion. It works :)