[Tracy Yaklyvich, MBA]

??Hi.  Is there a way to have a management reporter row be a constant value that is different for each column of the report?  I am looking to have a row for beginning net assets for multiple years.  Our GP balances in net assets are correct for the current year but not for prior years.

I would appreciate your help!

Thanks, Tracy

——————————
Tracy Yaklyvich, MBA
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————

[Samantha Higdon]

Hi ,

You can achieve it though you may need to get a bit creative and sacrifice some drill down ability.

1.) Create a row that has the net assets that you want to pull dynamically.  Consider this Row 100.
2.) Create a row that is listed as a calculation row.  This is where you will “plug and play” with values.  Consider this Row 200
3.) In the calculation row (row 200), set static values where you want constants (i.e. A=25000, B=30000, etc.).  That means that Column A of that row will show 25,000 while Column B shows 30,000, etc.  Repeat this for any and all columns you want to have a static value.
4.) In that same calculation row (Row 200), if you want a certain column to show the dynamic value (say current year), your “calculation” for that row would be C=@100.  This will pull in the dynamic value from the referenced row for Column C so you get a mix of static values and dynamic values linked to actual accounts.

The big downsides to this approach, in my opinion, include:
1.) The use of constant values means that if for some reason your static values change, you have to remember to go in and make the change manually.
2.) If you use this report year over year, you may have to modify your row definition each year. 
         A.) For example, if you only go 2 years back in the report itself but you need the data to be cumulative of all years to tie, static values from Column A and Column B may
               eventually condense into one number because they are years 3 and 4 back….but you won’t balance unless you roll them foward).?
         B.) Alternatively, you could keep adding columns to the report so you have ALL your years, but that still requires you to update the row and column definition to account
               for the passage of time.
3.) You can’t drill into that mixed value row that you create.  Since it’s a calculation, there is no drill down capability.  That’s really only a bummer for the one row that you pull dynamic value from for current yet.

Does that make sense?  If you’re a visual person, let me know, and I can mock up a row definition so you can see it.

If you have any questions, please let me know.

Best,

Samantha?

——————————
Samantha Higdon ,CPA,CGMA
Consultant
Lagom, LLC
Carmel IN
——————————
——————————————-

[Lucy Shows]

Another idea is to create a unit account for “NET ASSETS”, and populate it for each month you need.  ?Then you can just insert this account in the row you need and you can use it for whatever calculations you need. If you don’t use unit accounts regularly, it’s in Cards, Financial, Unit Account.  Be sure to check the box “Clear Balance During Year End Close” so it doesn’t behave like a balance sheet account rolling the ending balance into the new beginning balance.

——————————
Lucy Shows
director of budgeting and decision support
Hattiesburg Clinic P.A.
Hattiesburg MS
——————————
——————————————-

[Tracy Yaklyvich, MBA]

Thank you both for your responses.  Samantha’s suggestion works great!  I will try Lucy’s as well if I run into any issues.  Have a great day!

——————————
Tracy Yaklyvich, MBA, CAE
Controller
American Society of Health-System Pharmacists
Bethesda MD
tyaklyvich@ashp.org
——————————
——————————————-