I’m designing a table where the user will enter integer values in 5 different columns and I would like DW to calculate and save the average of those 5 columns in a 6th column before saving the record.
Any idea of how to do that? Would a SELECT function produce such result? And, if so, how would that function look like?
Thank you for your attention.