[Drew Rosen]

I have created a YTD cash flow statement in management with links in the reporting tree for excel to get the numbers for Fixed Asset purchases and long debt borrowing and payment on long term debt.  In the row definition I am using the following formula for the c=a6 /cpo where column d is Financial dimension column in my column definition.  I have the worksheets identified in my reporting tree specifying the worksheet link the workbook path and the worksheet name each worksheet name has separate company (all my companies are in 1 gp database).  On my worksheet have rows for the 2018 fixed asset purchases and another row for my 2019 fixed asset purchases by month.  In my column definition I would have a financial column base-1 for 2018 and base for 2019.  So c=a6 /cpo would put the  the fixed asset purchases for 2019 in column c and f=a10 /cpo would put the fixed asset purchases for 2018 in column f.  Columns b is beginning balance for 2019 column c is ytd balances for 2019 and column d is c-b.  Column e is beginning balance for 2018 and column f is ytd balances for 2018 and column g is f-e.  What do i use in my row definition.  I tries c=a6/cpo, f=a10 /cpo but this would not work.  Thanks Drew Rosen 910-221-3561

——————————
Drew Rosen
Carolina Services of Fayetteville, Inc
Fayetteville NC
——————————

[Steve Erbach]

,

That’s a little bit too much to visualize. I don’t suppose that you could take some screen shots of the pertinent bits of your descriptive text, could you?

Sincerely,?

——————————
“Sparkly” Steve Erbach – QMS Manager and Business Development Analyst
GLC Minerals, LLC – Green Bay, WI
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 R2 (16.00.0579) / MR 2012 CU16
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: twitter.com/serbach

——————————
Welcome to Dynamics!
You do not have permission.
Call Steve.
(hat tip: Lou Spevack)
——————————
——————————————-

[Drew Rosen]

Please see attachment for screen shots.  Thanks Drew

——————————
Drew Rosen
Carolina Services of Fayetteville, Inc
Fayetteville NC
——————————
——————————————-

[Drew Rosen]

?I forgot to attach the excel spreadsheet.  Thanks

——————————
Drew Rosen
Carolina Services of Fayetteville, Inc
Fayetteville NC
——————————
——————————————-