Here was what I found to be the recommended fix. Depending on your preference you will have two ways of creating this.
Method one
Create four different column definitions - one for each quarter (1-4) and a fifth column for calculation
In a new column (#1 for example) you will have:
Column type - FD
Book Code - 'your choice as my was budget info'
Fiscal Year - BASE
Period 1
Periods Covered - Periodic
Print Control - NP,P<=B
The 'B' column referenced above was a YTD total for something else
In a new column (#2 for example and so on)
Same attributes
Now that you have all four quarters, the fifth column would be the total so I set it up as follows:
Column Type - CALC
Formula - C+D+E+F (this represents the column buckets capturing each of the QTD amounts for each period
So in this method, you can reuse the column definition and change your 'Period' attribute to 4,5,6 and then 7,8,9 and lastly 10,11,12 and only have the one column definition.
Method two
Copy the column definitions out calling each one QTD 1, QTD 2, QTD 3, and QTD 4 with each column definition having the right periods in each.
Share
Report
156
All responses (
Answers (
