choosing from multiple values in formula

[#1]

One of our databases has multiple values for billing a customer:

I wanted to determine if a customer has a monthly fee or not. However, the formula

IF(Per_Bill.PMC_Code='MONTHLY',1,0)

always returns zero. I figure this is because QV sees the two possible values for the PMC_Code,

doesn't know which one to choose, and so evaluates the condition as NULL, and hence the result

is zero.

I've tried multiple combinations of conditions within the IF, to no avail.

Any one know how I might handle this?

thanks,

Kevin

[sunny_talwar]

Is this an expression or dimension?

[#3]

It's an expression

[sunny_talwar · Accepted solution]

See if this helps:

If(WildMatch(Concat(Per_Bill.PMC_Code, '|'), '*MONTHLY*'), 1, 0)

[#5]

Thanks, Sunny, that worked great!

[sunny_talwar]

Awesome

I am glad it helped. If you got what you wanted, can you close the thread by marking the correct answer and/or any helpful answers.

Best,

Sunny