Sage 100

Has anyone done a rolling 12 month trend report in Sage Intelligence? I had hoped SI would be smart enough that it would change the year if your subtraction in the period was less than 1, but I see that's not the case. Bummer.

You need to do an If Then Statement, looking at the next month and if =1 then 12 for the period and back off the year -1. I'm looking for the actual formula and will post if I find it.

Did you by chance look at the free reports for a trend?

There is Trend Analysis but it's graphical stuff