Net Change

asking

Using A/c Schedule what formula should i use to take out Net Change for every month for last 5 years ?

Alex_Chow

Use the Comparison Period Formula on the Column Layouts. The formula will be FY[1..5] (month 1 to month 5).

asking

I tried it didn't work, actually i want to display net change in columns in this manner

Jan Feb March April ....... for complete year.

Alex_Chow

Use the Comparison Period Formula and setup a line for each month.
so it would be:
FY[1]
FY[2]
....
FY[12]

asking

It worked =D> Thanks.

Alex_Chow

asking wrote:

It worked =D> Thanks.

Your welcome.

asking

Can i do the same for Vendors, Customers, Bank etc. ? If yes then How ?

Alex_Chow

asking wrote:

Can i do the same for Vendors, Customers, Bank etc. ? If yes then How ?

You have to setup dimensions and use the Analysis by Dimensions granule.