if condition does not work with multiple choices

[#1]

Hi!

I have problem with an if statement.

i have a chart with invoicenumber as a dimension and in my expression i want it to give me a value if the invoices is connected to a bookkeeping account.

so in my case i write =if(bk_account='1401','Yes','No')

and it returns "No" even if the invoicinumber IS connected to a bk account.

The only thing i can come up with is that this has to be because there's several bk_accounts connected to the invoice.

Am i right? And in that case, how do i solve my problem?

Thanks in advance!

//A.

[#2]

Hi,

Can you attach the application?

Thanks & Regards

Jai

[tresesco]

there could be several options, try this:

IF(Count(IF(bk_account=1401,'Yes','No'))>0,'Yes', 'No') // somewhat like checking existance

does EXISTS() help otherwise?

Regards, tresesco

[#4]

if bk_account is a number you don't need the quotes around it

[#5]

i have to put the exists in the script right? because i do this in the expression in a chart...

the one you provided with the "count" didn't work unfortunately.

And also, i've tried with and witout the quotes around 1401.

[tresesco · Accepted solution]

Sorry, there is a mistake in my previous expression. please try this:

IF(Count(IF(bk_account=1401,'Yes'))>0,'Yes', 'No')

Regards, tresesco

[#7]

Thanks! It worked!

/A.