Simple If condition in set analysis

[Anonymous]

Hi All,

I am trying use below expression to derive sales for different vehicles:

IF(vSelectedVehicle = 'MF','SUM({<vehicle={'MFV}>}sales')','SUM({<vehicle={'MAV'}>}sales)').

It is not computing the value. QVW has been attached

Thanks

Dasu.G

[alexandros17]

this is the correct expression

=IF(vSelectedVehicle = 'MF',SUM({<vehicle={'MFV'}>}sales),SUM({<vehicle={'MAV'}>}sales))

[jagan]

Hi,

Please find attached file for solution, for Actions -> Set Variable -> MF/MA

You should not give 'MF' or 'MA' with single quotes.

Hope this helps you.

Regards,

Jagan.