Hi

I have created a KPI and a scorecard for that. The actual is sales amount and target is budget. So far so good.

I have created the folowing formulas for the time intelligence filter.

Month - Current month
(year-1).Month - Current month last year
Month-1 - Last month
Month-5:Month - 6 months back

(YearToDate).FullMonth - Year to date full month

All the three first works great (which gives back only one month of calculations). but the next two which are supposed to sum() all months gives me an error with no more information.

I have configured the data source with a time dimension of a hiearchy (year, quarter, month, day). Selected reference member as 1/1/2000 and hierarchy level as day and reference date as 1/1/2000. I also connected the time member associations for each (year, quarter, month, day). 

• Edited by PatrikC Saturday, May 04, 2013 6:38 AM