Open Forum

Expand all | Collapse all

Management Reporter

Jump to Best Answer
  • 1.  Management Reporter

    GOLD CONTRIBUTOR
    Posted Oct 01, 2019 09:07 AM
    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
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Management Reporter
    Best Answer

    SILVER CONTRIBUTOR
    Posted Oct 01, 2019 11:22 AM
    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
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Management Reporter

    GOLD CONTRIBUTOR
    Posted Oct 02, 2019 08:51 AM
    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
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Management Reporter

    TOP CONTRIBUTOR
    Posted Oct 03, 2019 07:22 AM
    @Tracy Yaklyvich, MBA,

    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
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Management Reporter

    GOLD CONTRIBUTOR
    Posted Oct 03, 2019 08:38 AM
    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
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role