Peek() fetched the values from the specified table - if no table is specified the current table is taken and if the field isn't loaded there it has nothing to access to ... So it depends on the use-case which interrecord-function is more suitable. Peek() is mainly used for creating new fields, for example by accumulating anything or if not the previous record is taken else anyone which specified within the second parameter.
Further to make sure that the interrecord-feature worked like expected you should always add an appropriate order by statement to ensure the wanted load-order.
Hi, What you want to achieve with this peek() function in a first place? The peek() function usually is used to find specific value from your data. So, for example, line
peek('Volume',0,'T1') as P1
will provide you first value of 'Volume' column from table 'T1'. In your case I believe you are trying to see all 'Volume' values and Previous ones, so instead of
Peek() fetched the values from the specified table - if no table is specified the current table is taken and if the field isn't loaded there it has nothing to access to ... So it depends on the use-case which interrecord-function is more suitable. Peek() is mainly used for creating new fields, for example by accumulating anything or if not the previous record is taken else anyone which specified within the second parameter.
Further to make sure that the interrecord-feature worked like expected you should always add an appropriate order by statement to ensure the wanted load-order.
