Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Type mismatch when using zeroingll in Sage Intelligence

Posted By bethbowers 10 months ago

Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?

0 Doc102208 10 months ago

What is the error?

What is the syntax for the Zerogll formula?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 suzmwatson 10 months ago

I've had this when running a macro to hide rows. There were cells that had #REF for the formula result which were causing the type mismatch error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Doc102208 10 months ago in reply to suzmwatson

I use it all the time.

What is the error?

What is the syntax for the Zerogll formula?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 bethbowers 10 months ago in reply to suzmwatson

The cells were in the column you were checking for the 0 value, or the cells were in the row you were trying to hide?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 suzmwatson 10 months ago in reply to bethbowers

I believe they were in a cell that was included in the formula in the column that determines the zeros. I had to figure out which sheet it stopped on and they I could find the error.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Type mismatch when using zeroingll in Sage Intelligence

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING