Hey DataSnipper community!
Ever run into data type casting errors during audits, like when numbers are pulled as text and mess up your sums or formulas in Excel? Here's a quick tip on using Find All Sums (often called Find All Snip in automation workflows) to spot these sneaky issues efficiently.
What is Find All Sums?
Find All Sums is an automation tool in DataSnipper that scans imported financial docs (like statements or reports) for potential sums. It outputs results in Excel with two columns: "Total" (blue snips) and "Parts" (orange snips), verifying if parts add up to the total.
If there's a mismatch (white cells), it flags potential problems—including casting errors where numbers are treated as text, preventing proper addition.
How to Perform Casting Error ChecksImport your PDF or scanned docs into DataSnipper via the Excel add-in.Go to the Automation tab and click Find All Sums.Review the new sheet: Scroll the document viewer to see highlighted snips.Green/matching: Sum checks out.White/unmatched: Dig deeper—often text-formatted numbers causing casting fails.Manually verify with a Sum Snip or Exception Snip, add a note like "Casting error: Convert text to number," and fix in Excel (e.g., via Text to Columns).
This method saved me hours on recalc procedures—super handy for financial statement reviews! Pro tip: Combine with Text Snips for complex calcs.
Has anyone tweaked advanced options for better casting detection?
Share your hacks below! 🚀