Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
Kindly advise how to write a simple script to store the record numbers (Period) and values (Sales) of first & last records as memory variables for Period (P1=1 & P2=16) and Sales (T1=4.8 & T2=8.4).
Thank you
Tracy
Hi Tracy, if you add a condition to retrieve only files with sales:
Where Len(Trim(Sales))>0;
The variables can be created like:
LET P1 = Peek('t',0,'Sales');
LET T1 = Peek('Sales',0,'Sales');
LET P2 = Peek('t',NoOfRows('Sales')-1,'Sales');
LET T2 = Peek('Sales',NoOfRows('Sales')-1,'Sales');
Hi Tracy, if you add a condition to retrieve only files with sales:
Where Len(Trim(Sales))>0;
The variables can be created like:
LET P1 = Peek('t',0,'Sales');
LET T1 = Peek('Sales',0,'Sales');
LET P2 = Peek('t',NoOfRows('Sales')-1,'Sales');
LET T2 = Peek('Sales',NoOfRows('Sales')-1,'Sales');