Expression help

[#1]

Hi guys Ive got an expresion related question.

I have this expresion:

if(GetSelectedCount(Registr)=0,12,GetSelectedCount(Registr))

want to say only getselected count of registr when the operator of it is 'AAA'. (operator='AAA')  How can I add that in this expresion, Im not getting my desired result. There can be more Registr selected, therefore it only has to do this for operator AAA.

I prefer set anlysis, but didnt get it to work.

Thanks!

[sunny_talwar]

May be this:

if(GetSelectedCount(Registr)=0,12,Count(DISTINCT {<operator = {'AAA'}>}Registr))

[alexandros17]

If(Operator='AAA', if(GetSelectedCount(Registr)=0,12,GetSelectedCount(Registr)), 0)

let me know

[#4]

This doesnt work.

[#5]

This one works, only if I have operator AAA selected. But if I have another one selected too it doesnt work anymore.

It should still work then, but it should still only get the selected count where the registr belongs to operator AAA. Is this possible?

[sunny_talwar]

Try this:

If(WildMatch(GetFieldSelections(Operator), '*AAA*'), if(GetSelectedCount(Registr)=0,12,GetSelectedCount(Registr)), 0)

[#7]

so something like:

if(GetSelectedCount(Registr WHERE operator= 'AAA')=0,12,GetSelectedCount(Registr WHERE operator= 'AAA')), 0)

^this doesnt work of course.

[#8]

This doesnt work either. See my previous comment, it should behave like that. Can I?

[jagan · Accepted solution]

HI,

Try like this

=If(Count({<operator= {'AAA'}, Registr ={$(=GetFieldSelections(Registr, ','))} >} Registr ) = 0, 12,

Count({<operator= {'AAA'}, Registr ={$(=GetFieldSelections(Registr, ','))} >} Registr ))

Hope this helps you.

Regards,

Jagan.

[#10]

Correct! Thank you very much, would never found that by myself!