Store last value of a column in a varriable

[alec1982]

Hi guys,

I have a table as follow:

ID     Amount

1       200

2       250

3       100

Need to store the last value of amount which is 100 in a variable..

Let me know your thoughts..

Best,

Alec

[#2]

try this,

    = FirstSortedValue(Amount,  -Amount)

Hope this helps you

Regards,

Ashutosh

[nilesh_gangurde · Accepted solution]

Hiii,

TEMP:

ID     Amount

1       200

2       250

3       100

let vLastValue =  peek( 'Amount', -1, 'TEMP' ) ;

Hope this will help you.

-Nilesh

[VishalWaghole]

Hi,

PFA file,

hope it will work for you.

you need to create one variable as  vMax

then assign max(ID) value to vMax

ant use this variable in set analysis as

=sum({<ID = {$(vMax)}>}Amount)

Thanks and Regards,

Vishal Waghole

[MK_QSL]

Please check enclosed file....

You can get first or last value from any table field using PEEK function...

[jagan]

Hi,

Try this script and check the variable for value.

TEMP:

LOAD * INLINE [

ID,     Amount

1,       200

2,       250

3,       100];

let vLastValue =  peek( 'Amount') ;

Regards,

Jagan.