First record for a specific field.

[soha1902]

Hi All,

I need to create a formula where my requirement is sum(Sales) / first record from 'Sales' field.

Can any one suggest me how to find the first record value from chart expression.

Thanks in advance.

[Anonymous]

hi

use 'top' keyword.

sum( Sales ) / top( sum( Sales ))

HTH

Ravi N.

[Gysbert_Wassenaar · Accepted solution]

Use =fieldvalue('Sales',1)

[soha1902]

Thanks

Gysbert Wassenaar