3 Replies Latest reply: Feb 15, 2012 6:10 AM by tdecauxt

# IF in set identifier

Hello The Community,

So far, the community has answered all my question before asking, but now I'm stuck. So I hope you guys will help me

Here's the thing:

I am deseperatly trying to include an "IF" in a set identifer, but none of what I tried so far worked.

I am trying to count the number of existing Field_2 where Field_1 = vVariable_1, but if vVariable_1 is null, then I must count all the Field_2.

here is an example:

= count({\$< Field_1 = If( IsNull( \$(vVariable_1) ),'{*}',\$(vVariable_1))>} Field_2)

I hope I made myself clear enough you would help me out.

• ###### IF in set identifier

Why not create a second variable (let's call it vVariableCountExp):

=If( IsNull( \$(vVariable_1) ),'"*"',\$(vVariable_1))

and then use vVariableCountExp in your set element:

= count({\$< Field_1 = {\$(vVariableCountExp)} >} Field_2)

I don't think that you can use an if-conditon in the set element directly.

Stefan

• ###### IF in set identifier

Hi,

Can you try like this

If( IsNull( \$(vVariable_1) ),  count({\$< Field_1 = {'*'}>} Field_2),

count({\$< Field_1 = {\$(vVariable_1)}>} Field_2))

Hope this helps you.

Regards,

Jagan.

• ###### IF in set identifier

Okay that works for one.

But in fact, I have 4 différent Fields to set.

Like Count({\$<Field_1 = X1, Field_2 = X2, Field_3 = X3, Field_4 = X4>} Field_5)

And for each one I have to select either the Value of Xn or *.

It would mean to many imbricated to many different if, to assure all possible solution.