Skip to Content
avatar image
Former Member

Report Painter Prior Period Comparison

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers