Thanks Cataling again - you're right - it looks like having the 2 measures (balance & movement) is the way to go - thanks for pointing that out! ...
Great - thank you Catalin! Not only it provides scripts but also explanations, pointers - highly useful! I'm half-way there as in I created anot...
@Velouria - I can tell a genius when I see one!! Yet again you've hit it out of the park - thank you so much - exactly what was need!!
PQ is a valid approach but I'd still prefer a dynamic array - it's more mind-bending for one + it works without any 'mechanical' refreshes needed (and...
Guys - you blow my mind yet again!! Brilliant - thanks! Sorry Velouria - I should have specified that - for now it's a table but perhaps it migh...
Velouria - this was along the way I was trying to solve it - but failed where you did not - great! Janset - words fail me - it's unbelievable how simp...
yes, it would - so, all good there 🙂
re: rounding - PQ defaults to banker's rounding (to nearest even number). Use the 3rd param in the rounding to get the 'normal' result: Number.Roun...
See attached - tab [rslt (not elegant)] col [MyCalc].rnWord of caution - there are loads of MUCH BETTER way of doing that than the way I did it. The p...
I knew there were some really smart people here! Thanks!! (I wasn't sure if this should be posted as a different question - but it's directly linked t...
Thanks Mynda - yeah, table could do it mechanically but without the spill unfortunately. Thanks Riny - That's exactly the thing I'm after!! Thank y...