Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I need assistance please as I have been battling for a few hours.
How would I go about to add the difference from Q1 (11) to Q2 in the completed column making it 38? This will in turn change the difference for Q2 which will have to be added to the Q3 completed value and so on.
Any assistance will be much appreciated.
May be this
RangeSum(Completed, Above(Diff))
For Completed, use something like
=Rangesum(Above( Completed, 0, Rowno() )) - Rangesum(Above(Due, 1, Rowno() ))
Keep Due Unchanged.
Calculate Diff as
=Column(1) - Column(2)
edit: If you are using some aggregations in your expressions to calculcate Completed, etc.:
=Rangesum(Above( Sum(CompletedField), 0, Rowno() )) - Rangesum(Above( Sum(DueField), 1, Rowno() ))
Thanks Sunny and Stefan....RangeSum(Above(Diff)) works perfectly