Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Determine equipment usage

I want to determine the equipment usage for pieces of equipment by year. We have the information in a file that has Equip#, Transaction Date and Meter Reading. I basically want to take the first transaction for the specified year from the last transaction for the specified year to determine the annual usage. The transaction dates could vary by piece of equipment.

Does anyone have any suggestions? I'm using Crystal Reports XI.

Thanks in advance for the help!

Former Member replied

That shouldn't be too tough to pull off. We'd just need to know what fields you have available to work with.

Here is where I would start...

1) Filter you records by date, so set up you date parameters.

2) Hopefully each record has a unique ID field, that increments up each time a new record is input.

3) You'll need to group the report based on the equipment items (usually equipment_ID if you have one).

4) Next you'll need some formulas. Something along these lines:

Start

IF MINIMUM({tbl.eqipment_ID}, {#euipGroup}) = {tbl.eqipment_ID} THEN {tbl.meterReading}

End

IF MAXIMUM({tbl.eqipment_ID}, {#euipGroup}) = {tbl.eqipment_ID} THEN {tbl.meterReading}

Usage

{@End} - {@Start}

5) Place all 3 formulas in either the group header or the group footer (personal preference).

6) Suppress the details.

See how that works for you,

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question