Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..
I have formula like =count({$<DISPOSITION={"XA"}>} if(LASTMENUACCESSED=MENUID,MENUID,null()) ) in dash board..
but i have to avoid if(LASTMENUACCESSED=MENUID,MENUID,null()) in dashboard.
Please help me..
please find following attachment..
Thanks,
Hi jagan..
Please find following attachment..
In that the issue is last column(agent transferred) in straight table.
Thnaks,
Hi Sujeet..
Thanks for your reply..
actually in script i made lots of joins,so i want to make entire formula into set analysis formula with out if conditions..
Thanks,
Hi Jagan..
Is there any luk..
Thanks..
Hi Jagan..
Can you please help me...
Thanks,
Hi Perumal..
Thanks for your response...
Please find following attachment here agent trasferred expression is =count({$<DISPOSITION={"XA"}>} if(LASTMENUACCESSED=MENUID,MENUID,null()) ).
Can you give me any solution with out using if condition how to write above expression.
I used your formula its not working fine..
please help me...
Hi,
Try this expression
=count({$<DISPOSITION={"XA"}, LASTMENUACCESSED=P(MENUID)>} MENUID)
Regards,
Jagan.
Hi Jagan ..
Thanks for your reply..
Please find following attachment in this my formula gives 169118 count.But when i apply your formula it gives different result.Actual count is 169118 please help me..
Thanks,
Hi jagan..
Can we used replace function..
=count({$<DISPOSITION={"XA"}, LASTMENUACCESSED={$(replace(MENUID,LASTMENUACCESSED,MENUID))>}MENUID)
i used this but its not work please help me
Hi Jagan ..
Please Help me....
Thanks,
Hi,
I am unable to open the attached file, can you attach it again.
Regards,
Jagan.