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

    Use a LOD within a comma-dependent function

    Samuel Gee



      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.