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

null
    • subzwari
    • 4 yrs ago
    • Reported - view

    this is not a parant child relationship, but the two tables are related as seprerate tables.

    • Birger_H
    • 4 yrs ago
    • Reported - view

    It seems like no record matches the filter. And you can't devide by 0 :-)

    Birger

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1060Views