Set Expression

vanderson009 — Wed, 11 Dec 2013 07:20:14 GMT

Hi Community,

In my Database i have Stock data only for 1st Day Like

Day Production Sales Stock

01 2 3 11

02 4 2

03 5 3

04 2 2

See i have Stock 11 for 1st Day and

Production is 2 that means Total Stock is 13 and sales is 3 so 13 - 3 = 10

Means My Closing Stock for 1st Day is 10. and 2nd day opening stock is 10 and so on......

I want to Displya like this.

Day Production Sales Stock

01 2 3 11

02 4 2 10

03 5 3 13

04 2 2 13

Thanks and Regards,

Villyee

Re: Set Expression

arbernardez_old — Wed, 11 Dec 2013 07:53:19 GMT

Hello Villiyee,

I think this could be what you are looking for:

Stock_temp:

LOAD * INLINE [

Day, Production, Sales, Stock

01, 2, 3, 11

02, 4, 2,

03, 5, 3,

04, 2, 2,

];

Stock:

NoConcatenate

load

Day,

Production,

Sales,

if(len(trim(Stock))=0,peek(Stock)+peek(Production)-peek(Sales),Stock) as Stock

Resident Stock_temp order by Day;

drop Table Stock_temp;

exit Script;

Regards

Alberto Rodríguez.