Uh, click Start.... that takes you into Excel. FR is added to Excel under Add-ins as FR. No extra purchase necessary. Note that it only works with 32 bit Excel.

Click Help, Documentation and open the ENG folder, look for Financial Reporter User Guide. Follow the tutorial in the User Guide, it's not rocket surgery.

You need to use GL segments to do the report you are looking for. The canned reports are very generic, most companies require reports to be written for their needs.

You have a couple of other options:

1. Use Sage Intelligence instead of FR for reports - it has some better tools to do exclusions.  This will require some training or self-paced education on your part.

2. Use the GL code change program to modify your segment codes and make the ones you want to group contiguous.  This is the best solution if the change in reporting requirements is permanent.

yes, we use segments obviously.  only really trying to figure out how to pull out the -150 from a range of (-100,-101,-140, -150, -160, -180)

I looked in excel and don't see a financial reporting tools, so maybe I need to download some add-ons.  That being said, it doesn't really sound like a solution.  I'm not an idiot by any means, so please hold off on the comments.  We are all adults

I think Orchid's Information Manager (or Report Runner) might be able to handle this out of the box.  I've written a custom front end for FR that will allow you to print non-contiguous ranges like what you've described.  Start with Orchid and if that doesn't work then send me an email.

Another easy (free) way would be to have your first column having the entire range, column 2 just has 150 and then column 3 is column 1 - column 2.  Then hide 1 and 2.  It's a little clunky, but free.

Chill....

When you click START it loads Excel with the FR add-in, just try it. You do not have to install/buy/ download anything else.

You can easily exclude 150 in FR in the criteria in column B. But having your segment codes contiguous as Garry says will make your life easier.