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 ?
Sounds like you may have defined the field in the Values table. It should be defined in the Clients table.