I am struck here. Guys please guide me here...
I have a calculation
var 1
var 2
var 3
var 4... The sum of all should be reflected while entering, how can I make this??
ex:
var 1: 40
var 2: 0
var 3: 20
var 4: 60 (fill automatically instead of typing again)
I added coalesce() so that you get a total showing as soon as you start entering any of the values. Otherwise the others will return NaN, which will blow your total until you set all three to have a specific value.