Hi!!
First of all sorry for lengthy question.
I am facing issue with adding some calculations of a record from previous entry in same gallery. Its like update on the basis of previous entry in gallery. Let me explain with example:
Let say, I am working in Microsoft which has offices in different locations say US, India and UK. Each locations have different departments say HR, Finance and Sales. For each department there are employees and we are maintaining their expenses as per their department. During any month we are updating records like Date, Current Balance and Paid amount. There are other fields like Previous balance and Total which are calculated on the basis of last entry. Have a look at the below screenshot. I have attached same excel file for clear understanding of calculations.
Following are my questions:
1. How can I calculated and show "Previous Balance" in gallery.
2. How can I calculate and show "Total" in gallery?
3. There is starting point of "Previous Balance" which need manual entry. How can enter first entry for "Previous Balance" first time and rest it should be as per calculations in gallery?
4. Also, while doing all these calculations the gallery need to be filtered as per the Country, department selected in last screen.
Thanks in advance whoever takes this challenge and reply me with solution.
