Memory Variable Script

[tracycrown]

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

[rubenmarin · Accepted solution]

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');

[tracycrown · Accepted solution]

Dear Rubenmarin
Thank you so much for your help, you are very helpful.
Wishing you and your family a Happy, Healthy and Prosperous New Year 2019.
Tracy