Difference between two dates

[#1]

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

[nagaiank]

Try the expression

Floor([Clearing Date]) - Floor([Posting Date])

[#3]

no that did not work.

[#4]

Here is an example of my file