Forum Discussion

mshodge's avatar
mshodge
Frequent Visitor
9 years ago
Solved

Calculating Hourly Usage Data based on last entry

Seems like a simple problem however I cannot find a solution.  Can anyone assist?   Operators use a piece of equipment and then enter a series of checks for mainteance Items.  Within that they enter...
Need Help
  • mshodge's avatar
    mshodge
    9 years ago

    Sorry, none of the responses below I was able to get working.  I even bought the Russo and Ferrari book to try to understand the Earlier Function.

     

    I solved it within the source data.

     

    =IF(ISBLANK(D2),"0",Iferror(D2-large(QUERY($C$2:D2,"Select D where C matches '"&C2&"' order by D desc limit 2"),2),0))

     

    Line C is my vehicle ID and Line D is the hour reading the operators input each day. 

mshodge's avatar
mshodge
Frequent Visitor
9 years ago

Sorry, none of the responses below I was able to get working.  I even bought the Russo and Ferrari book to try to understand the Earlier Function.

 

I solved it within the source data.

 

=IF(ISBLANK(D2),"0",Iferror(D2-large(QUERY($C$2:D2,"Select D where C matches '"&C2&"' order by D desc limit 2"),2),0))

 

Line C is my vehicle ID and Line D is the hour reading the operators input each day.