
The system uses a parser that can evaluate mathematical and ifthenelse expressions. The following are the three major features of the parser:
1.Parses strings that contain formulas into expression objects that can be further evaluated.
2.Parses control objects to get the values they represent.
3.Evaluates expression and returns the result
Following are string formula expressions that the parser evaluates and return the result. Always use lower case when using the if, or, and functions.
Formula Expression

Return Value

Remarks

112/1.12*.12

12.00

The formula expression is a string type that the parser will evaluate.

(112/1.12)*.12

12.00

You can use ( ) for a more readable formula

if(5+2 > 5*2,'True','False')

False

Syntax: if(expression to be evaluated, return true value, return false value)

if(5+2 > 5*2 and 1=1,'True','False')

False

IF with AND function

if(5+2 > 5*2 or 1=1,'True','False')

True

IF with OR function

if(5+2 > 5*2, 'True', if(1=1, 'Still True', 'Still False'))

Still True

Nested IFs

if(#12/31/2020# > #12/31/2019#,'True statement','False statement')

True statement

Dates must be enclosed with #

if('y' = 'y' ,'True statement','False statement')

True statement

Strings must be enclosed with ' (single quote)

The parser includes ParseControlExpression that can retrieve the actual value from a given control or object. The following are the four controls or objects that the parser is capable to access and retrieve their values.
1. Date grid control. Click here for details.
2. Iinput panel control. Click here for details.
3. Pagination object. Click here for details.
4. Dataset object. Click here for details.

