This content has been marked as final.
Show 2 replies
-
Chart expression using max, if, count and distinct
jagan mohan rao appala Mar 5, 2012 1:05 AM (in response to Robert Hutchings)Hi,
Try this using AGGR()
=COUNT (DISTINCT Aggr(IF(Max(DATEFSR) < DATEIN,CALLNO), CALLNO))
Regards,
Jagan.
-
Chart expression using max, if, count and distinct
Robert Hutchings Mar 5, 2012 4:44 PM (in response to jagan mohan rao appala )jagan
Thank you.
It does exactly what I want.
-