How to Make this Output

[sona_sa]

Hi,

Please find the attached xls. Is it possible to make on behalf of same Actual Data.

Need side one Output on behalf of Actual Data.

Thanks

[Patricia_Silva]

Hello @sona_na, what is the output column based on?

[sona_sa]

Hi Silva,

On Behalf of April Month HC, I have to fill the data for May, June, July etc.

For May HC = April HC + May DOJ + May DOL = 4559+43+(-83) = 4522

Similarly June HC = May HC + June DOJ + June DOL = 4522+19+(-64) = 4477

Like This.

Hope you got my concern. Please help. Attaching xls.

Thanks.

[Ksrinivasan]

Hi. Go throu link and find your answer

https://youtu.be/A-kQPw9VMiY

[sona_sa]

You Tube is against the compliance in this system.

If You have any expression - please share.

Thanks.

[micheledenardi]

Temp:
LOAD
	Rowno() as Row,
    [Fiscal Month],
    HC,
    DOJ,
    DOL
FROM [lib://Expression Help.xls]
(biff, embedded labels, header is 1 lines, table is Sheet1$);

Final:
Load
	[Fiscal Month],
    if(Row=1,HC,peek(HC)+DOJ+DOL) as HC,
    DOJ,
    DOL
Resident Temp
	Order by Row asc;

Drop Field Row;
Drop Table Temp;