write max in dimension side

[#1]

Hi all,

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

[#2]

Hi jagan,

when I will try this expression Interval[Posting date] - [calender date], 'D') I will get difference between every calander date. I want Max(calenderDate).

When I will try this : Interval[Posting date] - max[calender date], 'D') then I will get error in formula.

[MK_QSL]

Interval(Max([Calendar Date])-[Posting Date],'D')

[#4]

NO still it is giving errror in formula.

[jagan]

Hi,

Can you attach sample file, so that it is easier to give solution.

Try this

Aggr(Interval([Posting date] - [calender date], 'D'), [Posting date], [calender date])

Regards,

Jagan.