US - Ohio (Columbus/Cincinnati)

Like what you see? Discover the benefits of the GPUG Community. Learn More

Management Reporter - Column formatting

Jump to Best Answer
  • 1.  Management Reporter - Column formatting

    Posted 06-12-2018 05:35 PM
    ​Does anyone know how to correctly format a column so that the variance calculates correctly for revenue, cost, and margins?  I only know how to do one variance formula for the entire column, but obviously it shows incorrectly at the margin line.  Is there a way to fix this??

    Thank you!!
    Karen


    ------------------------------
    Karen Carter
    Controller
    NaChurs/Alpine Solutions
    Marion OH
    ------------------------------


  • 2.  RE: Management Reporter - Column formatting
    Best Answer

    SILVER CONTRIBUTOR
    Posted 06-12-2018 05:45 PM

    Hi,

     

    Yes, in your column layout go to the variance column.  Double click on Print control and add XCR.  That changes the variance so that revenue show variances correctly.

     

     

    Teri Carpenter, CMA CBM

    Carpenter Associates, Inc.

    419-346-3401

    teri@caidynamics.com

    CAILogo

    facebook_smalltwitter_smalllinkedin_smallblog-small

     

    SummitPH18-DC-Email-Header.jpg

    Join your peers and other experts in Phoenix, Arizona now by registering with Early Bird pricing, a savings of $400. Early bird pricing ends June 28, 2018.

     






  • 3.  RE: Management Reporter - Column formatting

    Posted 06-13-2018 10:04 AM
    ​Teri is a genius!!  Thank you for your help!!!

    ------------------------------
    Karen Carter
    Controller
    NaChurs/Alpine Solutions
    Marion OH
    ------------------------------