Change in the Get Balance “all values” parameter (Release 3.85.0)
2 December 2008
Feature Description: Previously when leaving a particular Get Balance segment parameter empty, GL Wand would assume that you want all values for that segment. You had the option to either specify a “%” to denote all values or simply leave the segment parameter blank. This functionality has however caused problems in certain situations. For example a user copies and pastes a Get Balance formula onto a new row. The Get Balance formula is linked in the segment 3 parameter to column A, however on this new row the value in column A is blank. If your GL Wand calculation is it set to “On” this calculation will start and may take a long time to complete as GL Wand is assuming you want all values for segment 3. Feature Benefit: You must now specifically enter a “%”to denote all values. This gives GL Wand the ability to know whether you are specifically requesting all values or that you have simply not completed entering the formula yet. This change also prevents GL Wand from duplicating the calculations which can result in certain cases when Excel does not initially get the calculation dependencies correct. This can happen when you derive the segment values using an Excel formula like Mid or the GL Wand Split_Text.