Average

Hello,

I have two tables

Clients            Values

p_key----------<f_key

The Values table has 2 specific numeric fields:

Speed_Right

Speed_Left

In Clients layout a portal allow to enter up to 5 entries for Speed_Right and Speed_Left

In Clients table I need to calculate the Average of Speed_Right and Speed_Left

Since the Average value needs to be used in other calculations, I tried using the Average function as:

Average (Values::Speed_Right; Values::Speed_Left)

which does not work (I get the average only of the first record)

Anyone may help me please ?