I have an income statement that uses a "glclosingbalance" to come up with whatever period you put in the parameter. I am trying to find out what formula can I put in that will pull months 1-3, and months 4-6, and months 7-9 etc.

Views: 39

Reply to This

Replies to This Discussion

Michele - The Report Designer Add-In does not have a QTD formula.

To get the QTD numbers you can do the following:

You will need to create 4 columns for each Qtr.

Create 1 column and Use the GLActual formula.

In a row at the top of the each column you will setup the Period Numbers 1,2,3...

Link the GLActual Period parameter to the cell in the row with the Period Numbers.

Link the Year parameter to cell that holds the Current Year.

Create Col 2 & 3 as above.

Col 4 with be the QTD use the SUM to add each column up.

Here's an example

Do the same for the remaining 3 QTR's.

You can group the columns to the left of the QTD column.

Hope this helps.


Thank you!!

You're welcome.


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service