Calculation error

[everest226]

HI all

All i  want is if the Member is State and outifstate    multiply by  [2018 Guests].    i am getting some error.

if( [Member] ='State','outofstate', * Num([2018 Guests])

[lockematthewp · Accepted solution]

in the else part of your if statement, you must define what is to be multiplied. like:

if( [Member] ='State','outofstate', VALUE * Num([2018 Guests]))

or if you just want the number of 2018 guests,

if( [Member] ='State','outofstate', Num([2018 Guests]))

Also I noticed you are missing a close parenthesis at the end.

[Brett_Bleess]

Did Matthew's post get you what you needed or are you still trying to sort things out?  If his post did work, please be sure to use the Accept as Solution button on his post to mark it and give him credit for the help.  If you did something different, consider posting for others and then mark that, and if you are still working on things, leave an update.

Regards,
Brett