I am creating a Cash Flow report that has MTD and YTD columns with Accounts in the rows. Time is selected in the pages. In order for my Cash Flow Hierarchy to work out to get a correct Ending Cash Balance, I need a Previous cash balance account that shows the prior month cash balance if MTD column or the last year end cash balance if YTD column. Any suggestions?
Formula in Pro Calc that takes into account Time Perspective
2
1 reply