Removing Units from Value Column of the Engine Status Report

This Walk-Thru Will Guide You To Remove Units From The Value Cell

Provided by GPS Tracking Canada

..back to Custom Reports Knowledge Base

..back to Geotab User Resources

By default the Engine Status Report displays the value and units of each engine record in one cell of the Report sheet:

engine-status-report-1-1024x181

This looks and works great for most scenarios except when you want to manipulate the values, in this case you need to separate them into two different cells. If you click on the cell you will see that it is using the concatenate function:

=CONCATENATE(Data!M8," ",Data!N8)

The concatenate function is joining the content in Data!M8, the value, to that in Data!N8, the units. If you do not need the units then all you have to do is change the formula to:

=Data!M8

The result will look like this:

engine-status-report-2-1024x232

 

If you do require the units then you should insert a column to the left of the column you are in and add: =Data!M8 to one and =Data!N8to the other.

Doing that will look like this:

engine-status-report-3-1024x364

 

Once you have made the changes in the Report sheet you should go to the Summary sheet and refresh the Pivot Table.
You do this by right-clicking anywhere in the Pivot Table area and then selecting Refresh.

Check Pricing

All of our GPS tracking solutions are customized for your business and tailored to your budget...

Return on Investment

At GPS Tracking Canada, we understand that every company benefits from GPS Tracking in different ways...

Request a Demo

Get a live one-on-one demonstration from GPS Tracking Canada. See for yourself how customized...