Sage 100

HI
I believe I have it figured out.  Way too much brain power used on this one!
I've done many trend reports in SI but this 18 month one is kicking my butt.  I'm having problems getting the year to be the correct year since it's a rolling year.
So my far right column is January 2021, (period 1, year 2021),  I was able to get the previous 12 months  via formulas but now the next 6 previous months I'm confused!
Has anyone done an 18 month trend report that could give me the formula to get Year?


Thanks
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

@Joe Uhl​

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

I believe you will need to use one of Excel's most powerful functions, the "nested if" statement.  It is similar to the "if then else" and the "case" syntax used in other programming tools.  I like to start by writing out the logic in pseudo code, then converting the pseudo code to formulas or program statements.



------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------

Hi Nancy,

I have done quite a few trend and rolling trend reports. I use year rows and month rows for doing this logic with if formulas. When previous month is 1 than change year to previous year minus 1 and month is 12. I then point SI functions to these cells for the year and period in the column. If you need more detail let me know.

------------------------------
Joe Uhl
Eide Bailly, Inc.
------------------------------