Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Hi.
Calculations are based on the business need. I could see only few column in the excel.
Get this requirement from your client/partner. For requirements and what they want only they can help you.
Sachin
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.
Hi Jonathan,
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.
Thanks,