1 Reply Latest reply on Nov 4, 2016 2:41 AM by Samuel Gee

    Use a LOD within a comma-dependent function

    Samuel Gee

      Hi,

       

      I want to check the datediff using a FIXED LOD that's using a dimension hierarchy:

       

      DATEDIFF('weeks', {FIXED [Store Number],[County]:MIN([Sales Date]),[Current Date]}

       

      The problem is that daisy chaining Store Number and County in the Fixed expression uses a comma, which Datediff interprets as the comma between the start and end date we're comparing. So I can't then complete the formula.

       

      This feels like a bug? Or at least an oversight.

       

      Is there a way around it?

       

      Many thanks for your time.