please share the formula for closing balance as well.
Can you try removing SUM from the formula?
Ohh, you don't have "closing balance" as column? if not you can try like
Closing Balance = [Opening Balance] + [Deposit]
First of all.. Thanks for your response. The main question is for creating opening balance we need closing balance.. but for creating closing balance we need opening balance.. I have tried to created duplicates as well.. but still could not make it.. please help me achieve this . This task is burning me like anything. Once again thank you very much @nikunj
These are the following steps I followed for created the sheet. Please let me know where did I go wrong.
Step 1: I have dragged year , months into columns and deposit into rows.
Step 2: Created a parameter named "opening balance"
Step 3: Created a calculated field "opening_Bal" and inserted "opening balance" parameter into it.
step 4: Created a calculated field "closing balance" with formula opening_Bal + Deposit.
Step 5 : Tried to edit the opening balance calculated field with the formula which is there in your screen shot. but I am facing multiple errors.
Please help me out
Look at the 2nd row of your screen shot.. closing balance of feb is not the sum of previous 2 records.
Please share your workbook with dummy data. that would be great.