Hi everyone, could you please help me to modified the following load script?
Year(GRTVAL_FECCAL) & Num(Month(GRTVAL_FECCAL),'00') & Num(Day(GRTVAL_FECCAL),'00') as %Key_CREATED_ITEMS_MOVIMIENTOS_VENTAS,
what i have is
but what i need is
|10/2/2014||4 (10/1/2014 value)|
|10/3/2014||5 (10/2/2014 value)|
|10/4/2014||6 (10/3/2014 value)|
|10/5/2014||7 (10/4/2014 value)|
is it clear?
You may actually want to do this in the table you are displaying the data in itself. This could be done using the ABOVE() function. This function will display the value of a cell that is a specified distance above. The Syntax is:
Above([TOTAL] Expression [,Offset[,n]]).
If you do not specify or use the TOTAL qualifier it will default to displaying the value of the row directly above it. If this is something that has to be done in the load script however, this will not help