Set Analysis

[Anonymous]

Hello, good if someone can help me please, I would appreciate it very much.

I need that the day, month, year, date not only correspond to that variable, but to another that is called vMaxDay.

Current code:

sum ({<day, month, year, Date = {"$ (vLastDay)"}, FLAG_TITLE = {'S'}, CATEGORY = {'Available for Sale'}>} PRICE_MERCED)

[Digvijay_Singh]

Do you mean Date needs to be compared with vLastDay AND vMaxDay? Are these variables assigned Date value in date format?

sum ({<day, month, year, Date = {$(vLastDay)>*<day, month, year, Date = {$(vMaxDay)>+< FLAG_TITLE = {'S'}, CATEGORY = {'Available for Sale'}>} PRICE_MERCED)

[jwjackso]

If Date is your transaction date and the variable vLastDay and vMaxDay are in the same format, you could try the following if you are trying to get data between the 2 dates:

sum({<Date={">=$(vLastDay),<=$(vMaxDay)}, FLAG_TITLE = {'S'}, CATEGORY = {'Available for Sale'}>} PRICE_MERCED)

Also check out creating a calendar table, How to create a Calendar

Once you have a calendar table you can build variable for different time periods, like a prior MTD and just drop the variable into the set analysis.

LET vPriorMTD = Replace('MonthID = {"@(=Max(MonthID) - 1)"}, Date =  {"<=@(=AddMonths(Max(Date), -1))"}','@','$');

[Anonymous]

Thanks Digvijay, Let me check the code.

[Anonymous]

Thanks Jerry for your valuable contribution. I will keep in mind to create a Calendar.