topic Re: DIFFERENCE BETWEEN DATES in App Development

DIFFERENCE BETWEEN DATES

Wed, 10 Feb 2016 12:06:24 GMT

I have a table with date, customer, quantity and I need to know the variation amount from the previous date

EXAMPLE: CUSTOMER 3 ON 21TH -> 198-148= 50

swuehl — Wed, 10 Feb 2016 16:54:20 GMT

If you want to calculate this in the script:

Result:

LOAD

Customer,

Date,

Quantity,

If(Previous(Customer) = Customer, Quantity- Previous(Quantity) ) as Diff

RESIDENT YourTable

ORDER BY Customer, Date;

DROP Table YourTable;