calculations in datalist
I have a data list with multiple columns and rows. The value in one field (in a specific column) is to be calculated from user's inputs in two other fields (in the same row). I managed to set it up by using "on change" or "lost focus" in each of the two fields. To do this, I needed to repeat the formula in each of the two fields, setting the value of the result field. I don't think repeating the formula is right way.
What I'm looking for is way to set the formula once, and get the result field updated when any of the two fields are updated on change or losing focus. No sure where this formula needs to be set, whether in the On Data Change of the row, or on page load etc. Or do I need to use a datamaster to do so?