Answered YTD weird behavior

  • Wednesday, July 12, 2006 2:23 PM
     
     
    Hi there,
    I have a strange issue with the time intelligence wizard. I created a YTD with it but some measures behave very strange. It looks like the values arent aggregated correctly:



    Current Periode Year to Date
    2/jan/06 All 17 17
    3/jan/06 All 29 39
    4/jan/06 All 29 60
    5/jan/06 All 44 94

    2 measures behave like this, one (calculated) stays blank and one give a "NA". All the other measures (calculated and normal) work like a charm!

    I just ran the wizard, and didn't change the code afterwards...

    Any clues?
    Thanks in advance!

    Cheers,
    Tim

All Replies

  • Wednesday, July 12, 2006 2:53 PM
     
     Answered
    I discovered the reason: Both had DistinctCount as AggregateFunction.

    Case closed!

    Cheers,
    Tim