[Tracy Yaklyvich, MBA]

Good morning. How do you hardcode an amount into an MR row so that it differs by column? I know there is a way but I can’t figure it out! Thanks in advance.

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

[Gerald Buenafe]

Hi Tracy,
You can create a calculated column in the column format and out the amount in, then from your row format, you can access that column from the row format using the column filter

——————————
Gerald Buenafe
Owner/Consultant
BTP Technologies LLC
CHANTILLY VA
——————————
——————————————-

[Chris Donnelly]

Tracy,

You may want to use a unit account (cards > financial > unit account).

Chris

——————————
Chris Donnelly
Sr Mgr of Info Systems and Financial Reporting
Healthmark Industries
——————————
——————————————-

[Barbara Gavron]

,

Perhaps you are looking to replicate something like the Fixed Assets line in a standard Cash Flow? If that is the case you can create a Calculated row (CAL) and then just populate the formula with something like ?B=(123.45),D=987.65. You only have to reference columns that you wish to have the hard-coded amount in. And the nice thing is that these amounts can be used in any of the remaining formulas as you move down your row format.

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-

[Tracy Yaklyvich, MBA]

Hi Barbara, this will definitely come in handy for some other items we are struggling with.  Gerald helped me fix my immediate problem.  Thanks for all of the responses and the call Gerald!

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