Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks Jagan Mohan
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.