Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
The below condiiton i used for set anaylsis gives me correct result . ( in the below expression I was trying to show Either case_ID or TAX_ID should not be empty )
count({<Dep={'Customs'},ID={"=Len(CASE_ID&TAX_ID)>0"}>}ID)
Now i want to show both case_ID and Tax_ID should be empty ,How can I change this expression accordingly ?
Thanks in Advance
try this
count({<Dep={'Customs'},CASE_ID={"=Len(CASE_ID)=0"},TAX_ID={"=Len(TAX_ID)=0"}>}ID)
@smilingjohn try below
count({<Dep={'Customs'},CASE_ID={"=len(trim(CASE_ID))>0"},TAX_ID={"=len(trim(TAX_ID))>0"}>}ID)
try this
count({<Dep={'Customs'},CASE_ID={"=Len(CASE_ID)=0"},TAX_ID={"=Len(TAX_ID)=0"}>}ID)