Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to write max function in dimension side without using sum.Administrator
If you mean calculated dimension, probably you have to use AGGR() function to use any aggregation function like your max().
Hi,
I want difference between Posting date and max(calender date) ,
so how to write it in dimension side.
Hi,
Try like this
=Rangemax([Posting date], [calender date]) - Will give you the max date in this two dates
= Date ([Posting date] - [calender date]) - Will give you the difference between the two dates
Can you attach some sample data.
Regards,
Jagan.
If you give us some more information, will be useful to give you right direction..
I need the no of days between the posting date and max CalenderDate.
I have a calender in my report where I will select for eg. 7/31/2013
and my database has the field Posting Date with different dates.
So for each posting date I need the no of days with Calender Date.
eg.
1. Posting date is 6/25/2013.
So no of days between 7/31/2013 and 6/25/2013 is 35 days.
2. Posting date is 7/20/2013.
So no of days between 7/31/2013 and 7/20/2013 is 10 days.
So my calender will always be same until user changes the date selection in the calender.
Please see the sample data.
CalenderDate: 07/31/2013
Posting Date | No of Days |
07/31/2013 | 1 |
07/30/2013 | 0 |
07/29/2013 | -1 |
07/28/2013 | -2 |
07/27/2013 | -3 |
07/26/2013 | -4 |
07/25/2013 | -5 |
07/24/2013 | -6 |
07/23/2013 | -7 |
07/22/2013 | -8 |
07/21/2013 | -9 |
07/20/2013 | -10 |
07/19/2013 | -11 |
07/18/2013 | -12 |
07/17/2013 | -13 |
07/16/2013 | -14 |
07/15/2013 | -15 |
07/14/2013 | -16 |
07/13/2013 | -17 |
07/12/2013 | -18 |
07/11/2013 | -19 |
07/10/2013 | -20 |
07/09/2013 | -21 |
07/08/2013 | -22 |
07/07/2013 | -23 |
07/06/2013 | -24 |
07/05/2013 | -25 |
07/04/2013 | -26 |
07/03/2013 | -27 |
07/02/2013 | -28 |
07/01/2013 | -29 |
06/30/2013 | -30 |
06/29/2013 | -31 |
06/28/2013 | -32 |
06/27/2013 | -33 |
06/26/2013 | -34 |
06/25/2013 | -35 |
So I need to create this No of days column on dimensions side in Pivot table.
Is number of days is field or it is a result from some of your calculation?
it should be a calulated dimension
Hi,
Try Interval() like this
=Interval[Posting date] - [calender date], 'D')
Regards,
jagan.
No my question is NO OF DAYS need to be calculated based on POSTING DATE?
if yes, you can use like below..
Dimension = [Posting Date]
Expression
Max(CalendarDate)-[Posting Date]+1
or
Max(CalendarDate)-[Posting Date]