Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
I have a report that runs with an opening and closing total from 201201 on a monthly view.
When doing a straight table, it gets very lengthy and was wondering if there is a way to not show months 201201 to 201809 and show only from 201810 on words, but the opening balance starting from 201810 pulls from the closing balance on previous months, thus taking these columns away changes the values in opening and closing balances of the report.
Any Idea on how to do this.
Try calculating the Opening and Closing Balances in script
can you please post some sample data and your expected result?
thanks
Marco