The "is blank" function in a calculation now calculates even when a field has not been entered
When you do any calculations in the system, ALL of the fields needed to be available in order for a calculation to calculate
Previously, when "is blank" was used in a calculation, the calculation would only calculate when the variable was either calculated as blank or entered as blank. The calculation using "isblank" would not calculate if it was blank because it was not entered. To get around this an interim calculation need to be added that included a a "safe" equation to return 0 if no data has been entered (as shown in the image below).
To get the calculate to calculate using isblank, you had to add in an interim calculation that returned safe (0) if not data was entered in a particular field, and then change the equation from an isblnak to a > or < equation.
Now, you can use the "isblank" in any calculation and it will automatically calculate if the cell is blank; either because no data has been entered, or because it has been left blank
The example here shows that the Number 1 field has been left blank. Previously, this equation would not have worked. Now the calculation works correctly.
0 Comments
Add your comment