I have monthyear, billing extended price, booking extended price and salesperson columns.
I have created closing balance like bookingextendedprice-billingextendedprice = closing balance, but opening balance I am not able to create. Please give me some Idea here, these things I have to create in script. Please find the sample data.
If you have movement only (bookingextendedprice - billingextendedprice), then you cannot compute both the opening AND closing balance. You need one and you can calculate the other, but you cannot compute both from movements only.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
I have two column, I thought booking-billing =closingbalance values are the closing balance for each month, so we can get the peek(closingbalance) as openingbalance. Lastmonth closing balance is the opening balance for the next month. so I thought like that.
Could you please give me some structure how it should be in source table.