difference between Max date corresponding value and second max corresponding value?

Thu, 04 Sep 2014 09:56:03 GMT

Hi All,

I have below data

Formula: Hrs=(max date corresponding hrs-2nd max date corres Hrs) /(max date-2nd max date)

Ex: Engine A=(15-15)/(11/3/2014-11/3/2014)

Engine B=(30-25)/(10/3/2014-12/2/2014)

=5/28.

Numarator: Hrs difference

Dinaminator: Days difference.

I need to calculate this in back end because in chart i need to show in year and month wise.

Date means service date

Re: difference between Max date corresponding value and second max corresponding value?

tresB — Thu, 04 Sep 2014 09:58:41 GMT

Straight table:

Dimension: Engine

Expression: =(FirstSortedvalue(Hrs, -Date) -FirstSortedvalue(Hrs, -Date, 2))/ (Max(Date) -max(Date,2))