Set Analysis with two or more conditions in variable

[test_it_1234]

Hello,

i need some help.

I  have this formular:

=count(DISTINCT {<STATUS_PRODUKT={"$(v_switch_status_produkt)"}>}Vertragsnummer)

STATUS_PRODUKT can be 'aktiv' or 'in Bearbeitung'

Now i can set the variable v_switch_status_produkt to 'aktiv' or  'in Bearbeitung', this works fine.

How can i set the variable to  the condition  'aktiv', 'in Bearbeitung'?

I have tryed this but it is not working.

v_switch_status_produkt=Chr(39)&'aktiv'&Chr(39)&Chr(44)&Chr(39)&'in Bearbeitung'&Chr(39)

But the output looks correct to me.('aktiv','in Bearbeitung')

[test_it_1234 · Accepted solution]

i find the error by my self 🙂

change this to

=count(DISTINCT {<STATUS_PRODUKT={"$(v_switch_status_produkt)"}>}Vertragsnummer)

to

=count(DISTINCT {<STATUS_PRODUKT={$(v_switch_status_produkt)}>}Vertragsnummer)

[tresesco · Accepted solution]

Try removing double quotes, like:

=count(DISTINCT {<STATUS_PRODUKT={$(v_switch_status_produkt)}>}Vertragsnummer)

Since your variable evaluation would itself have single quotes, this should work.