Lou Wagner
  • Male
  • Albuquerque, NM
  • United States
Share

Lou Wagner's Friends

  • Jesse Braun

Lou Wagner's Groups

 

Lou Wagner's Page

Latest Activity

Lou Wagner joined Sage Alchemex's group
Aug 11
Lou Wagner replied to Jesse Braun's discussion Hiding zero lines on sheet with Data Validation drop down
"You are very welcome. Glad it helped! Lou"
Apr 11, 2016
Lou Wagner replied to Michele Herzog's discussion Using the ZeroingII Add In Function
"That works in a formula but I don't know how to use it in the macro unless you have two columns to the side of the data and then have the macro check both values. That would be pretty clean and simple........ Lou"
Apr 8, 2016
Lou Wagner replied to Michele Herzog's discussion Using the ZeroingII Add In Function
"Lisa, You'd have to insert a code loop into the macro that tests all of the cells in the row to see if any are not zero. If it finds a value, either positive or negative, it exits the loop and resumes on the next row. I'm not a programmer…"
Apr 7, 2016
Lou Wagner replied to Michele Herzog's discussion Using the ZeroingII Add In Function
"Somehow, a critical line up there was wrecked. It should read sh.Rows(i).Hidden = Application.Sum(sh.Range("O" & i).Resize(, 36)) = 0 Lou"
Apr 7, 2016
Lou Wagner replied to Jesse Braun's discussion Hiding zero lines on sheet with Data Validation drop down
"Jesse, Also, take a look at this macro http://www.sageintelligencecommunity.com/forum/topics/using-the-zeroingii-add-in-function It may do what you need. Lou"
Apr 7, 2016
Lou Wagner replied to Michele Herzog's discussion Using the ZeroingII Add In Function
"Below is the macro I use. One (minor) downside is that it hides zero rows in hidden worksheets but that doesn't affect functionality. Another downside is that it hides rows which net to zero, ergo, if there is a debit in one column and a credit…"
Apr 7, 2016
Lou Wagner replied to Crystal Brantley's discussion Job Profitability Report
"Interesting problem.   Off-the-cuff brainstorming:   You won't be able to modify standard Sage reporting in Intelligence, however, using the field list in the report might give you a head start on accessing the right tables and fields…"
May 27, 2015
Lou Wagner replied to Erin Roundy's discussion Distribution issue with custom filter on report
"Here's a macro that may help.   1. It's not perfect. Someone with much better skills than I, should be able to fix it up. 2. You WILL have to modify it for your needs with the correct column to test and the correct number of rows…"
May 18, 2015
Lou Wagner replied to tammy Kiaei's discussion no value
"Two things come to mind: 1. Be sure you're running it with the right company code (Sometimes, it's the little things!) 2. Make sure all of the macros are enabled in Excel   Lou"
Apr 28, 2015
Lou Wagner replied to Craig Fisher's discussion Report Design Add-In problem with Segment Delimiter
"Peter,   Wouldn't that require them to have a Connector license?I'm looking forward to trying this solution.   Thank you!   Lou"
Mar 18, 2015
Lou Wagner replied to Doug Jenkins's discussion Period end date
"The way I do this is to create an additional tab just after the Notes tab.   In that tab, I have a table starting in A1 called Periods_Table with the columns: Period, Month, Descr, Date   Period are two characters so you have to…"
Mar 7, 2015
Lou Wagner replied to Shwu Hua Gan's discussion What's wrong with this Excel formula?
"That was the one I was thinking of.   Also, try turning off the Force Book Recalculation option. It's not generally recommended because it requires that you recalculate the spreadsheet after it has been created.   Be sure the…"
Dec 5, 2014
Lou Wagner replied to Shwu Hua Gan's discussion What's wrong with this Excel formula?
"I suspect that the range names are being created by SI after the formula column has been inserted into the spreadsheet.   For some reason, I think I've read where you can turn off the calculation for the spreadsheet until after all of the…"
Dec 4, 2014
Lou Wagner replied to Fabian White's discussion Intelligence Reporting or Microsoft Excel 2013 hangs?? Not sure of the cause...
"Yes. My workaround is to be sure Excel is not running before I hit the run button in SI.   Lou"
Nov 21, 2014
Lou Wagner replied to Sandra Smith's discussion Select reporting tree at run time using Report Designer Add-In report
"I'm having a similar issue.   We have created several templates, each with more than 100 tabs, one tab for each reporting unit on the tree. These templates all use the same tree. As large as the Excel templates become with so many tabs,…"
Jul 21, 2014

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence
Website
http://redw.com
How long have you been using the above solution?
30 years
Where did you hear about us?
Other

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2017   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service