I'm trying to create a little tool for the salesfolk which calculates 2 lists and then subtract one sum from the other, then multply to another field.
My problem is, when I change items on List1 the calculation does not occur correctly unless I change something on List2. In fact I tried a workaround with a Trigger button to restart calculation (which seems to work), but don't like that.
Could you think of better way ?
Unfortunately I can't send my file here.