In need of support?

Support is provided on a first come, first served basis through email. Additional sources are:

  • Help and Tutorial: RulesBase includes an extensive help file and a Language Tutorial.
  • Support KnowledgeBase: the Gray Box Software website, located at www.grayboxsoftware.com maintains a knowledgebase of known issues.
  • Contact if you can not find an answer. We also welcome comments or suggestions at .

* - denotes required field

* Name:
* Phone:
* Email:
* Comments:
 

Knowledge Base

How To Insert an Exception into a column

Published October 02, 2006

RulesBase is designed to have one formula represent the results of a column of numbers. However, the user may also create an exception to a formula while retaining the audit trail.

Suppose we have rules:
"Data = {3000,4000,2000,1000,4000}"
"Base Formula = Data * 75%".

The exception in Row 3 might be "Exception = item(3,Data) * 80%".

Finally, to replace the Base Formula with the Exception use the formula:
"Final Result = item(1 thru 2,Base Formula) | Exception | item(4 thru 5, Base Formula)"

Return to Knowledge Base