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

[amitrathi239]

Follow below steps.

Sort the table data in ascending order by VIN and date.

Add extra column and place bthe below formula

V Milage=If([Milage]<Previous([Milage];([VIN]))) Then Previous([Milage];([VIN]))-[Milage]

Filter on the V Milage variable whwre greater than 0

[mikasand]

Thanks! It worked great after adding the Nofilter . Report now working as I want to !