Condition Structure
A basic condition is generally made up of three elements: the element to be compared, a comparison operator, as well as a test value.
[Total current assets]>5000.00
Although the element to be compared is often a cell in a form, it could also be a function within the list of available functions. For example, with the GetReturnStatus() function, you can set up a condition which allows you to select all the client files containing returns with a "Rolled forward" status:
GetReturnStatus() = "Rolled forward"
In addition, a condition can be made up of several cells and operators.
Advanced options
Use last year’s value
When this option is selected, the condition will use last year’s value instead of this year’s value.
This can be useful if you want to check to see if an amount was entered in the prior year for a specific cell.