I am performing an averaging calculation and am joining 2 tables.
Setting "missing on" will set the value to blank if the child record exists and the field I'm averaging is blank.
However, the issue I'm having is when there is no child record at all, the field I'm averaging is set to zero rather than blank and is giving incorrect results.
How do I set "missing on" with a missing instance/record condition?

This message has been edited. Last edited by: Med1,

In the GUI, the are two different options. One is 'missing on needs some data' and the other is 'missing on needs all data', I feel like you might want to try the latter and see how it works. I'm assuming you are using a define to create your fields. You can also use

 SET NODATA = ' ' 

in combination with this.

Is it also possible you could do it in two passes, one where you retrieve the information and get all the rows you need then do the averaging?