write max in dimension side

[#1]

Hi all,

I want to write max function in dimension side without using sum.Administrator

[tresesco]

If you mean calculated dimension, probably you have to use AGGR() function to use any aggregation function like your max().

[#3]

Hi,

I want difference between Posting date and max(calender date) ,

so how to write it in dimension side.

[jagan]

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.

[MK_QSL]

If you give us some more information, will be useful to give you right direction..

[#6]

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.

[MK_QSL]

Is number of days is field or it is a result from some of your calculation?

[#8]

it should be a calulated dimension

[jagan]

Hi,

Try Interval() like this

=Interval[Posting date] - [calender date], 'D')

Regards,

jagan.

[MK_QSL]

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]