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