Need max age

[prma7799]

Hi All,

I want max age of the field...

=if(num(num(date(today())- num(BL_DT_VPC)),'####'),(num(num(date(today())- num(BL_DT_VPC)),'####')))

Thanks

[#2]

try with age function.

[prma7799]

I got two values using (num(num(date(today())- num(BL_DT_VPC)),'####') )

but I want max of above two values...

[kamielrajaram]

Hi Prashanti,

Try

Aggr(max(your formula),Dealership)

Regards

Kamiel

[prma7799]

Dealership is not my dimension I just rename the filed.

when I am using max(num(num(date(today())- num(BL_DT_VPC)),'####') )  

in expression then I get max value..

[mambi]

you can use this function FirstSortedValue()