Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): SAS Institute Inc

Description (Required): Oracle OTBI does not have a running difference function.

Use Case and Business Need (Required): OTBI has a Running sum (RSum) and a Moving sum (MSum). The running sum can be reset by a variable but the moving sum cannot be. There is a need to track deltas in some business situations. Example, a project budget. When the project budget starts with for example, $50,000 and additional funds are added after some time, the project budget is now $65,000, the user would like to know that the additional revenue that came in during the month of budget change was $15,000 which is the difference between the current budget and the previous budget value for the project.

Enhancement Request / Service Request:

Add a new function RDiff which will compute the running difference between rows.

Workaround

Here is some improvisation that I did with MSum and RSum to arrive at my own RDiff!