I need date following other day in set analysis

[dseelam]

HELP,

I Have a field a with different values it has warranty start date end date contract start and end dates

so total of 4 dates I need Contract Start date following or equal to warranty End date in set analysis

Example:

TYPE	WARRANTY START	WARRANTY END	CONTRACT START	CONTRACT END	COUNT
ACTIVE	01/01/2012	01/01/2013	01/02/2013	01/02/2014	1
TERMINATED	01/01/2012	01/01/2013	01/01/2013	01/02/2014	1
SIGNED	01/02/2012	01/01/2013	10/02/2012	01/02/2014	0
null field	-	-	-	-	1
hold	01/02/2012	01/02/2013	05/05/2014	01/09/2017	1

Thanks in advance

[jagan]

Hi Dinesh,

Do this in script like this, it is easier and performance would be better

Data:

LOAD

*,

If([CONTRACT START] >= [WARRANTY END], 1, 0) AS Flag

FROM DataSource;

Now in Set Analysis simply use

=Sum({<Flag={1}>} Count)

Hope this helps you.

Regards,

Jagan.

[dseelam]

Thanks Jagan Mohan

[jagan]

Hi,

Please close this discussion by giving Correct Answer to the helpful post if your problem is resolved, it helps others in finding the solution.

Regards,

Jagan.