Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hiii,
TEMP:
ID Amount
1 200
2 250
3 100
let vLastValue = peek( 'Amount', -1, 'TEMP' ) ;
Hope this will help you.
-Nilesh
try this,
= FirstSortedValue(Amount, -Amount)
Hope this helps you
Regards,
Ashutosh
Hiii,
TEMP:
ID Amount
1 200
2 250
3 100
let vLastValue = peek( 'Amount', -1, 'TEMP' ) ;
Hope this will help you.
-Nilesh
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
Please check enclosed file....
You can get first or last value from any table field using PEEK function...
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.