Skip to Content
0

Report Painter Prior Period Comparison

Jun 27, 2017 at 02:05 PM

34

avatar image

Hello all,

Hoping someone can shed some light on an issue I'm facing with Report Painter.

I am trying to create a report painter balance sheet report with the following columns:

a) Column 1 - Prior Year Cumulative Balance

b) Column 2 - Prior Month Cumulative Balance

c) Column 3 - Current Year Cumulative Balance

So, for example, if I ran the report for the June 2017, then the columns would display the cumulative balance for:

Column 1 = June 2016 Cumulative Balance

Column 2 = May 2017 Cumulative Balance

Column 3 = June 2017 Cumulative Balance

I'm having issues trying to get values for the 3 columns. Do I have to write some custom formula?

Would really appreciate your thoughts.

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers