Hi ,
Thanks for the reply .
Yes i am loading actuals data from a source system .and the data is not changing
I am tm1 beginer .could you guide me how to write ti for average and how to loop back to last 12 months using parameter .
Search found 3 matches
- Tue Jan 06, 2015 9:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average of last 12 months excluding months which dont have d
- Replies: 4
- Views: 4689
- Mon Jan 05, 2015 11:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average of last 12 months excluding months which dont have d
- Replies: 4
- Views: 4689
Re: Average of last 12 months excluding months which dont ha
I wrote rule bt could not get the exact count of months which have data
rule
[count]=N:if(['Revenue_meas1'] <> 0 ,1,0);
rule
[count]=N:if(['Revenue_meas1'] <> 0 ,1,0);
- Mon Jan 05, 2015 9:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Average of last 12 months excluding months which dont have d
- Replies: 4
- Views: 4689
Average of last 12 months excluding months which dont have d
Hi i want to calculate the last 12 months avgerage .but i dont want to hard code the denominator 12 .if i have data for 5 months then my denominator shuold be 5 . how to implement .suggest me ideas . Thanks in advance Ravi skipcheck; ['12MonthAvg'] =N: if(dimix('Time Period', !Time Period)<=12,Stet,...