• Community
  • Blog
  • Contact
  • Customer Downloads

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.
  • "We saved about 50 hrs. a month on intercompany reconciliations thanks to faster data compilation using GL Wand"

    Michelle Wallace, Arbonne International, LLC

  • "It’s great to work with a group so committed to providing not only a great product but stellar service as well."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • "GL Wand is a fabulous tool, we love it."   

    Donna Holley, Spectranetics

  • "This has to be the quickest ROI we've had on any software investment."

    J Raffensberger (MBA), Corporate Controller, Glatfelters

  • “GL Wand has been a big hit with Cairn’s Finance team."

    Chris Hebden, Cairn Energy PLC

  • "It took less than two hours to train report users. The time savings for everyone is incredible."

    Francis Nocom, Applications Manager, Cochlear

  • “GL Wand has proven extremely valuable in accessing our Oracle data with Excel."

    Michael Hinck, Finance Systems Project Manager, HBO

  • "GL Wand has given our finance users the freedom to think outside the box and be more innovative with performance metrics."

    Martin Stanton, Chief Information Officer, Destination Hotels & Resorts

  • "GL Wand has given our finance users a very flexible tool."

    Paul Simpson, Lancashire County Council