Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this is the correct expression
=IF(vSelectedVehicle = 'MF',SUM({<vehicle={'MFV'}>}sales),SUM({<vehicle={'MAV'}>}sales))
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.