Peek Issue

[dineshm030]

Hi Legends,

Peek function is not working in Resident table.

Below is screenshot for your reference.

Thanks in advance.

[MK_QSL]

Try

Peek('SV1') as Peek1

or

Peek('Peek1') as Peek1

Also don't forget to use correct Order By syntax.

[sasiparupudi1]

Peek('Sales Volume') as Peek1

Use Orderby Month clause.. hth

the peek takes a string input

[sasiparupudi1]

field_name

Name of the field for which the return value is required.Input value must be given as a string (for example, quoted literals).