Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i try to show Opening Amount over a period of four months.
however only the second month (Feb) shows the correct values for Opening .
Mar and Apr are showing 0.
How to get the TOTAL Values of the above months Description into the Opening Field ?
And how to get the correct Value for TOTAL in Feb, Mar, Apr?
Check this out
if(sum(Opening)=0,
Sum(Aggr(RangeSum(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2), 1, RowNo())), Description, Date)), Sum(Opening))
May be this
If(sum(Opening)=0,
Sum(Aggr(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2)), Description, Date)), Sum(Opening))
But shouldn't the total change based on the new opening and then the opening for the subsequent month should also change?
Yes exactly! The Opening is now correct but
the TOTAL should always consider the new Opening Amount!
Use this for Total....
Column(1) + Column(2) + Column(3)
But since the total changed, would you not want the Opening to be based on new Total
Exactly , thats the problem 🙂
Check this out
if(sum(Opening)=0,
Sum(Aggr(RangeSum(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2), 1, RowNo())), Description, Date)), Sum(Opening))
thank you so much sunny
No problem at all... I am glad I was able to help