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 1 month 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?

Parents

0 suzmwatson 1 month 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 bethbowers 1 month 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 1 month 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

Reply

0 suzmwatson 1 month 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

Children

No Data

Sage 100

Type mismatch when using zeroingll in Sage Intelligence

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING