Share
Report
1,501Hi There,
I need to create a YTD Trial Balance. Each month needs to show the ending balance.
My column layout is similar to the following:
Column B = YTD/BB (beginning balance)
Column C = Periodic, hard code 1 for January. I have an NP Print Control
Column D = CALC = B+C - This gives me the ending balance for January.
Column E = Period, hard code 2 for February. I have an NP Print Control
Column F = CALC = D + E - This gives me my ending balances for February.
I repeat this format for the entire 12 months. My problem is that when I run the report for February 2015, I get the same ending balance from February (Column F) for every period, even though I only have actual GL balances for January and February.
How can I design my report so I don't get balances (ending balance for February) for March, April..December? In other words, how can I prevent CALC fields for future periods from printing? I know suppression is not available for a CALC field, so I'm trying to find another way to make this happen.
Any help would be much appreciated!
Thanks,
Steve
*This post is locked for comments
All responses (
Answers (
