Compile (CM) Messages › › IDCMRWER13 - Nullable field may not have Average function

IDCMRWER13 - Nullable field may not have Average function

Reason:

You cannot calculate an average from missing data. NULL is not treated as zero or any other specific value for calculation in CA Ideal.

Action:

If an average is required that is the result of adding all non-NULL values in the column and dividing by the number of rows reported, you can achieve it by reporting a work-field that is set to the value of the column if non-NULL, or zero if NULL. Other possible meanings of average require calculation in the program.