I have two tables
The Values table has 2 specific numeric fields:
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 ?