Business Reporter - Year to date for designated period; Prior Year to date

Its hard to tell from your screenshot, but I’ll assume your info source is GL Balance and your measure is GACT_GL_BALANCE.BALANCE.  One way to get the data by adding parameters for AccountingYear and AccountingYearPeriod:

When you run the report, you enter appropriate parameters, from your example 2023 and 202307, you would get YTD data.

If you simply want to have all of the PTD columns, as in your screenshot, then total them in excel, you can do that too 

Thanks you. That will work for current yar to date. But, How can I get prior Year to date? 

In a similar manner - add function parameters for PreviousYear and/or PreviousYearPeriod

Hi Cynthia

Can you show what you have for the PreviousYear.  I am trying to build a report based on year and not yearperiod. What do you have for the PreviousYear?

Barbara

Hopefully this will be what you are looking for:

Cynthia

Thank you.  Is there a way to do it for multiple companies.  My report pulls data from two companies.  I have a report filter for the companies. 

Barbara

I’m not sure.  Our reports are built for a master company in Group Consolidation. 

I think though, that as long as your years/period are consistent across all companies, if you set it up using one of them, BR will apply it to all in the report.

Cynthia 

Thank you for your help.  I have put in the function parameters.  I think I am missing a step. How do you see the actual prior year in the data.  In my data pull, I list period, account, and balance.  What I need is to compare the period to prior year period.  So, what I would want is the period, account, current year balance and prior year balance.  How would I tell BR to put prior month balance in the column?

Barbara

Hopefully this is what you are asking.  To see the actual prior year you filter your BR column on the prior year function parameter: