Need SAP BI report with function to find VIN with tampered odometer mileage

[mikasand]

I want to build a SAP BI document where I process a lots of vehicle data in order to find vehicles with tampered mileage odometer. The data table include VIN, and Date / Mileage at each service visit.

I am absolutely a beginner and need help with some simple coding, how to set up the variables in SAP BI 4.2 Web interface, so the report can process and find the VINs with manipulated mileage odometer.

Normally the mileage increase when the car is used. I want to find these VIN's where mileage has decreased with previous date.

The example show 2 VIN's which one have a tampered mileage.

sap-bi-example-picture.jpg
sap-bi-example-text.txt

[mikasand]

Thanks!

It was working to find all the tampered VIN's, however the value in the added column "V Mileage" is blank after applying the filter "Greater than" = 0. The report is working since I can find the concerned VIN's, BUT it would be nice to know how much mileage has been tampered. If it is easy to fix to display also the Lowered Mileage, please assist.