Backdated Aging

muhammedraleen — Tue, 02 Feb 2021 09:04:27 GMT

Already i have created 3 tables for displaying backdated aging of last three months. Assume i have selected january 31st 2021.

In first table, dimension is if($(vMaxDate)-GRNDate >365 and $(vMaxDate)-GRNDate <=730,'Over 1 year',if($(vMaxDate-GRNDate >730,'Over 2 year'))) and measure is stockvalue. this table showing aging value from jan 31st 2021.

In second table, dimension is if(addmonths($(vMaxDate),-1)-GRNDate >365 and addmonths($(vMaxDate),-1)-GRNDate <=730,'Over 1 year',if(addmonths($(vMaxDate),-1)-GRNDate >730,'Over 2 year'))) and measure is stockvalue(date adjusted to addmonths($(vMaxDate),-1). this table showing aging value from dec 31st 2020.

In third table, dimension is if(addmonths($(vMaxDate),-2)-GRNDate >365 and addmonths($(vMaxDate),-2)-GRNDate <=730,'Over 1 year',if(addmonths($(vMaxDate),-2)-GRNDate >730,'Over 2 year'))) and measure is stockvalue(date adjusted to addmonths($(vMaxDate),-2). this table showing aging value from nov 31st 2020.

Now I need all three tables into one table. Anyone can help on this.

topic Backdated Aging in App Development

Backdated Aging