Avatar

Level 10

Do you have a dynamic or fixed dimension table?

Looks like you have a fixed dimension table here...

Using -> [*] is to specify each instances of that object inside the subform specified... Here if you have more than one PSI into Row5 it would work... But as I understand you have to write only Avg(Row3.PSI, Row4.PSI, Row4.PSI)

If you have a dynamic table and your row is only named Row1... each instances of the row would be Row1[0], Row1[1], Row1[2]

So in your Average function you would only write :

Avg(Row1[*].PSI) and it would return the average of each rows