0
Formula giving invalid result
I have a related table and on the parant table form I want to find the average of records from the related table. the formula I am entering is
let x := Id;
sum((select Synoptic where Id = x).Temperature) / cnt((select Synoptic where Id = x).Temperature)
the result is invalid. can you advise where I am making a mistake.
2 replies
-
this is not a parant child relationship, but the two tables are related as seprerate tables.
-
It seems like no record matches the filter. And you can't devide by 0 :-)
Birger
Content aside
- 5 yrs agoLast active
- 2Replies
- 1062Views