I am still having a problem getting my form to calculate an average the way it should. On one form I did when I set up an formcalc to average ten places and not average any cell that is blank or null I used the [*] and works just fine, but on the next form that I did that only has three rows it includes the null cells even through I used the [*] function. What am I doing wrong?
if a cell is null value, it should consider this value as 0... anyhow you don't want it to get the average with a 0, you must validate the field to see if it's different then null
Okay, well make sure your avg function is being used in formcalc language
make sure your field is calculated readonly
and that you are in the calculate event of the field
and if all those are correct, can you show me your lines?
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, Row1, Row1
So in your Average function you would only write :
Avg(Row1[*].PSI) and it would return the average of each rows