need help with set analysis

[#1]

i have a field using dual function,

and i have created a toggle button - (i checked its behavior it is working fine with number i.e.1,0 not with the string)

now the problem in set analysis when i use

{<num(field)={'variable'}>}

please find attached document

[Anonymous]

Far easier to use the text values for a dual(), and set vShowDev to U or whatever text value you need.

     count({<Bulk_Flag={'$(vShowDev)'}>}Bulk_Flag)

[#3]

the problem is that other value have space in string "N U"...  and in second value i want to pass 'U','N U'

how can i handle this?

[#4]

and as i told button is not behaving good when i use if(vShowDev=0,'U','N U')

with this, button is worked for one time only

[sunny_talwar]

Tried using the if?

=Count(If(Bulk_Flag = vShowDev, Bulk_Flag))

Best,

Sunny

[Anonymous]

count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"}>} Bulk_Flag)

[sunny_talwar]

PFA the application.

Best,

Sunny

[#8]

Hi Michael ,urs idea is working ...

can u please explain me the logic

[#9]

Hi Gurjeet,

PFA application.

Hope u are looking the same.

Thanks,

Ashok.

[Anonymous]

It is not allowed to use functions here:

{<num(field)={'variable'}>}

It must always be field name:

<field={something}>}

Now, replace "something" with any expression you may need, in this case:

<field={"=num(Bulk_Flag)=$(vShowDev)"}>}"}>}