Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try the expression
Floor([Clearing Date]) - Floor([Posting Date])
no that did not work.
Here is an example of my file