Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello @sona_na, what is the output column based on?
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.
Hi. Go throu link and find your answer
You Tube is against the compliance in this system.
If You have any expression - please share.
Thanks.
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;