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…
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…
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…
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 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…
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…
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…
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…
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…