3 Replies Latest reply: Jan 9, 2013 1:50 PM by Zhenya Virina RSS

    Difference between two dates

      Hi -

       

      I am trying to create single line chart that will display the difference between Clearing Date & Posting date by Regrion. For some reasons when selecting one dimension and adding single calculated measure, values are not appearing on my chart.

       

      Any help?

       

      As my Dimension I am selection Region

      and this is what i have for my expression:

      interval("[Clearing Date].[Date].[Date].[MEMBER_CAPTION]"-"[Posting Date].[Date].[Date].[MEMBER_CAPTION]",'dd')

       

      Thank you

       

      Z