Opening Amount

[Frank_Hartmann]

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?

[sunny_talwar]

May be this

If(sum(Opening)=0,

Sum(Aggr(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2)), Description, Date)), Sum(Opening))

[sunny_talwar]

But shouldn't the total change based on the new opening and then the opening for the subsequent month should also change?

[Frank_Hartmann]

Yes exactly! The Opening is now correct but

the TOTAL should always consider the new Opening Amount!

[sunny_talwar]

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

[Frank_Hartmann]

Exactly , thats the problem 🙂

[sunny_talwar · Accepted solution]

Check this out

if(sum(Opening)=0,

Sum(Aggr(RangeSum(Above(Sum(Opening) + Sum(Contributions1) + Sum(Contributions2), 1, RowNo())), Description, Date)), Sum(Opening))

[Frank_Hartmann]

thank you so much sunny

[sunny_talwar]

No problem at all... I am glad I was able to help