Issue after concatenating

[Anonymous]

Dear All

I have two tables  Table1- Sales and Table2- Outstanding.   I have concatenated both tables.

Both have Date field of their own.

The Sales table field--->  YearMonth  is linked to calendar.  I am given alias YearMonth to date field of Outstanding.

I am trying to create a report which has to show both Sales and Outstanding amounts for the previous month.

For which I use variable in Set analysis as  vPrevmonth.

Variable is defined as below:

vPrevmonth = Date(addmonths(max([MonthYear]), -1), 'MMM-YYYY')  .

However I do not get the desired result for Sales and Outstanding. The output works for only one field either Sales or Outstanding.

Not for both.

Is there any modification required?  Kindly help.

Thanks & Regards

Chintan Gala

[sunny_talwar]

It should be same format and same date... 01/01/2017 is Jan-2017 and so is 01/31/2017. So by using MonthStart we are forcing dates to be the start of the month.

[Anonymous]

The date in outstanding table is different than that of Fact table.

I am trying to alias it same name as that of Fact table. Is this causing issue ??

[sunny_talwar]

I don't think that is an issue. If you are connecting these tables in MonthYear and you wish to use MonthYear in a set analysis, may be sure they all have same format

[Anonymous]

Hello Sunny

Thanks for all your help. I am able to get the desired result now!

Thanks & Regards

Chintan