Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this as your expression:
=Count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"} + {"=num(Bulk_Flag)=0"}>} Bulk_Flag)
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)
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?
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
Tried using the if?
=Count(If(Bulk_Flag = vShowDev, Bulk_Flag))
Best,
Sunny
count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"}>} Bulk_Flag)
PFA the application.
Best,
Sunny
Hi Michael ,urs idea is working ...
can u please explain me the logic
Hi Gurjeet,
PFA application.
Hope u are looking the same.
Thanks,
Ashok.
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)"}>}"}>}