As Of Help???

[gauthamchilled]

Hi,

I attached qvw file. I need a help on Asoftable.

When i select Asofyear - 2016, asofmonth - march and period type as YTD.

data for march value is

but when i just toggle the month from mar to april...the march value changes..

can any one help?

Thanks.

Gautham

[gauthamchilled]

I think the data for march 31st is converted to april automatically...can any one help ?

[asgardd2]

I think you don't have a full data model (all variants of links)

For example Total  Premium  = 1615706,8390509 don't linked to Apr 2016 .

If i understood coorrectly you need data model, like this (for ex. 1 year):

IncomeDate - MonthYear

Jan 2016 - Jan 2016

Feb 2016 - Feb 2016

Feb 2016 - Feb 2016

March 2016 - Jan 2016

March 2016 - Feb.2016

March 2016 - March 2016

...

[Gysbert_Wassenaar]

Your AsOf calendar is not linked to all the dates. If you select Apr then jan 31 and march 31 are missing.

I also don't understand why you use every single income date as MonthYear instead of creating as MonthYear field from only the start date of the month. See this example: AsOf Table Examples.qvw