Formula for Random Record that Field

[hartmut]

Hi

I am not sure that random function applies. But I would like to make a calculation to get a random record and a particular field for that record.

random (record) "ThatField"

Thanks

[Raybaudi]

Hi

try this one:

GetNthRecord ( ThatField ; Ceiling ( Random * Get ( TotalRecordCount ) ) )

... and make this calculation "Unstored"