Hi I'm trying to get the difference between two dates. I need to create a Calculated member to show it. I'm using this formula
PeriodDays = LastDate - FirstDate
For example, I have a Time Dimension, I choose two dates:
FirstDate = 07/04/2006 it's identity is 300
LastDate = 15/04/2006 it's identity is 308
PeriodDays = 308 - 300 = 8 this value I need to show in a Calculated Member
The Time dimension has three levels
Year, month and date
What happens when I choose only a month?
Thanks
Dear,
I dont understand onething u are talking about date diffrence and u are giving an identity example.
Pls explain in detail.
Regards
Sufian
|||Hi, ohh, I will try to explain again
I need to get how many days are between two dates, For example, I choose two dates from my Time dimension
Date1 = 07/04/2006
Date2 = 15/04/2006
Days = Date2 - Date1 = 15/04/2006 - 07/04/2006 = 8 days and this value I need to show in a Calculated member
Is it possible?
My time dimension has three levels
Year, Month and day
Can I do this operation, with the month level?
Regards
Thanks
