Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can someone help convert this into set anlysis code thanks
COUNT (If (Comp_Status = 'WorkingWith' AND Terr_ChildCount = 0 AND isNull(Comp_Deleted),Comp_Status))
COUNT ({<Comp_Status ={ 'WorkingWith' }, Terr_ChildCount = {0} AND Comp_Deleted={''}>}Comp_Status)
Try this expresion.
Hi,
Try this expression
=Count( {<Comp_Status={'WorkingWith'}, Terr_ChildCount={'0'}, Comp_Deleted-={'*'}>} Comp_Status)
Regards,
jagan.
Hi, Try this code:
=Count({<Comp_Status={'WorkingWith'},Terr_ChildCount={0}>}if(isNull(Comp_Deleted)=-1,Comp_Status))