Excel – How to calculate the difference between two dates

The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months years days - ignoring years days - ignoring months and…

Excel 2016 – Auto-sum not working until edit formula or save spreadsheet

Problem When updating an Excel spreadsheet, formulas do not update automatically as values are entered or updates. Instead - the formula only updates after the formula is edited or the…

Crystal Reports – Display running total as 0 when null value

The following steps show how to display a NULL value (a blank value) as a 0. This can be helpful when you need to use the value to perform calculations…

Crystal Reports – How to fix ‘Division by zero’ error

Problem When running a Crystal Report you receive the following error message Division by zero. Solution Before describing how to work around this issue a quick explanation. When you see…

Gravity Forms – How to do advanced number field formula calculations

Gravity Forms provides the ability to perform basic calculations in 'number' fields, such as 'field 1 x 2' or 'field 1 + field 2'. As of Gravity Forms 1.9.15 these…

Learn SQL using FREE online interactive SQL tutorials

If you're interested in learning coding, specifically SQL, then this resource may be helpul. It's a fully interactive tutorial which steps you through SELECT queries, performing basic calculations, using JOIN…

SQL Query – Find numbers with more than two decimal places

As a database administrator one simple health check you can perform on the information in the database is that dollars are being saved correctly to two decimal places. Quite often…

SQL – Divide by zero error

Problem When running an SQL view using SQL Management Studio you experience the following message: MSG 8134, Level 16, State 1, Line 2 Divide by zero error encountered. Solution This…

Word 2010 – Calculations using mail merge fields

One of the little known features of Microsoft Word is the ability to do calculations based on mail merge fields. The process is as easy as creating an expression field…