
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis unable to exclude common record
Hi Team,
I wanted to compare two dates value and need to show only those records which are not present in previous month last day and
present in current month last day i.e i wanted to exclude all common record between these two dates and put only non-matching records.
I have tried the below expression
varibale define
for getting last day of current month
vLastDayPrevMon=MonthEnd(AddMonths($(vFromDate), -1))
LastDayCurrMon=MonthEnd($(vToDate))
=if(Date='$(vLastDayPrevMon)' AND Date='$(vLastDayCurrMon)',ID)
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This entire value
Count(DISTINCT {<DATE = {[$(=Date(Floor(MonthEnd(Max({<ID>}DATE), -1))))]}>} DATE) + Sum(0)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Counting DISTINCT Dates where Date = last date of the previous month.... and seems like adding Sum(0) to avoid nulls because of the set analysis on date....

- « Previous Replies
-
- 1
- 2
- Next Replies »