- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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