Sage Home    Go to sage.com
Sage Accpac Community
Accpac Support Community
Home Blogs Forums Knowledgebase Resources Your Feedback
Search in

In FR, how to get the MAT (Moving Annual Total) for P&L?

Sage Accpac Community » Sage Accpac ERP » Reports, macros, and customizations » In FR, how to get the MAT (Moving Annual Total) for P&L?
Last post 10-22-2009 5:41 PM by TimRichardson. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 10-21-2009 11:30 PM

    In FR, how to get the MAT (Moving Annual Total) for P&L?

    Reply Contact

    I can I suppose cobble the last 12 months together:

    =FRAMTA("NETYTD")+FRAMTA("NETY.L1")-FRAMTA("NETYTD.L1")


    (I hope that works, I haven't tested it yet)


    I find the FR documentation sometimes a little hard to read .... I wonder if there's a better way.

  • 10-22-2009 12:28 PM In reply to

    Re: In FR, how to get the MAT (Moving Annual Total) for P&L?

    Reply Contact

    =FRAMTA("NETPY")

  • 10-22-2009 5:41 PM In reply to

    Re: In FR, how to get the MAT (Moving Annual Total) for P&L?

    Reply Contact

    Thanks. And

    =FRAMTA("NETPY.L1")

    is the same, but for the prior 12 months, giving two years of MAT comparison.

Page 1 of 1 (3 items)