locked
YTD function not working in Dashboard Designer RRS feed

  • Question

  • Hi,

    In Dashboard Designer(DD) I'm trying create a scorecard that has YTD calculations. When I create the KPI i add the following syntax in the custom MDX formula:
    SUM(YTD([Time].[Monthly].CurrentMember),[Measures].[Amount])

    When previewing the dashboard in DD, it's gives me only the amount of the chosen month, not YTD amount. I've tried to publish, refresh, opening and closing the DD without success.

    I also tried to use PeriodsToDate function with same result.

    Any idea what might be my problem here? Does DD maybe not support YTD functions?

    cheers,
    Gosi

    Friday, October 24, 2008 8:07 AM

Answers

  • YTD functions in MDX are supported, I am not sure why you saw the strange behavior initially.

    Thanks,

    Alyson

     

     

    Wednesday, October 29, 2008 2:15 PM

All replies

  • I created a whole new project with the same logic, and then it works perfectly. What could be the cause of my other project is not working correctly, has someone experience this before?

    Gosi
    Friday, October 24, 2008 10:19 AM
  • YTD functions in MDX are supported, I am not sure why you saw the strange behavior initially.

    Thanks,

    Alyson

     

     

    Wednesday, October 29, 2008 2:15 PM