IF Statement

[danielnevitt]

Hi,

I have the following variables:

I would like to create an expression in a straight table that says something like the following:

If Group=Fuel Oil then vFuelOil*(an expression I have created) or

If Group=Gasoline then vGasoline*(same expression as the above) or

If Group=MidDist then vMidDist*(same expression as the above)

else 0

Is the above possible?

Thanks,

Daniel

[Anil_Babu_Samineni]

Yes, I think we can.  but,  Can we have the expression

[Anonymous · Accepted solution]

if(Group = 'Fuel', vFuelOil * [expression],

  if(Group = 'Gasoline', vGasoline * [expression],

  if(Group = 'MidDist', vMidDist * [expression])))

[varshavig12]

=if(Group = 'Fuel', vFuelOil * [expression],

  if(Group = 'Gasoline', vGasoline * [expression],

  if(Group = 'MidDist', vMidDist * [expression]   ,0    )))

[danielnevitt]

Marcio/Varsha,

Thank you both for your help.

Regards,

Daniel

[sunny_talwar]

Just as a way for slight improvement, you can use Pick(Match()) here

Pick(Match(Group, 'Fuel' , 'Gasoline', 'MidDist'),

vFuelOil ,

vGasoline,

vMidDist) * expression