Set Analysis unable to exclude common record

[Karim_Khan]

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)

stalwar1‌

[sunny_talwar · Accepted solution]

For the sample provided... this seems to work

Avg({<DESC = {"=Count(DISTINCT {<Date = {[$(=Date(Max(Date)))], [$(=Date(Floor(MonthEnd(Max(Date), -1))))]}>} Date) = 1"}>} 1)

[Karim_Khan]

Hi Sunny Thanks for ur help a always bt still some challenges while trying to implement it with my dynamic calendar date

this exprssion in working for dynamic dates but while m trying to combine ur also its giving null values

=IF(Date='>$(=Date(vFromDate))<$(=Date(vToDate))',

Avg({<ID= {"=Count(DISTINCT {<Date= {[$(=Date(vFromDate))], [$(=Date(Floor(MonthEnd(vToDate))))]}>} Date) = 1"}>} 1))

[sunny_talwar]

Can you share a sample to show the issue?

[Karim_Khan]

sorry have missed one filter if will apply then its working

=Avg({<ID = {"=Count(DISTINCT {<DATE = {[$(=Date(Floor(MonthEnd(Max({<ID>}DATE), -1))))]}>} DATE) + Sum(0) = 0"}>} 1)

Thank You so much stalwar1

[sunny_talwar]

Hahaha awesome and you deleted the whole post and rewarded yourself the correct response. Great going .

[Karim_Khan]

m really sorry by mistakenly i selected that will rectify it now only. and have deleted that screenshot only.

[Karim_Khan]

stalwar1‌ sorry  it was mistake and unintentionally

[Karim_Khan]

Hi Sunny,

   Can u pls help me out to understand the below expression

=Avg({<ID = {"=Count(DISTINCT {<DATE = {[$(=Date(Floor(MonthEnd(Max({<ID>}DATE), -1))))]}>} DATE) + Sum(0) = 0"}>} 1)

[sunny_talwar]

What do you not understand?