|
How should I write the expression if I want this statement to be true? |
#If or #ElseIf expression |
Boolean operation |
|
Is field A filled in? |
?A |
A |
|
Is field B missing (not filled in)? |
1-?B |
!B |
|
Are both field A and field B filled in? |
?A * ?B |
A AND B |
|
Are both field A and field B empty? |
(1-?A) * (1-?B) |
!A AND !B |
|
Is field A not filled in but field B filled in? |
(1-?A) * ?B |
!A AND B |
|
Is field A or field B filled in, or both (at least one of them)? |
?A ?B |
A OR B |
|
Is either field A or field B filled in, but not both? |
(?A*(1-?B))+((1-?A)*B) |
A EXOR B; that is, (A AND !B) OR (!A AND B) |
|
Given a series of 5 fields called "A", is at least one of them filled in? |
?A[1]:?A[5] |
— |
|
Does field C have a field complement? |
?&C |
— |
Inserting conditional transaction fields into a transaction description