Description
The EQUAL (==) operators tests whether two values are equal.
Usage
a == b
Remarks
The value of the expression is TRUE if the two values are equal, and FALSE if they are not.
Generally, a and b must have the same type. That is, a and b must both be numbers, or text, or dates. However, if either a or b are of different types, but one is text, then the other will be implicitly converted to text using the same conventions as the TEXT function.
When comparing text, the comparison is case sensitive. That means that "ABC" does not equal "abc".
Examples
Verify that disaggregates add to the same number
If you are collecting both breakdowns in gender, and age group, you might want to verify that they sum to the same total. You could use the validation rule:
MEN + WOMEN == ADULTS + CHILDREN
Ask additional questions for specific areas
If you have a reference to a country or province form, you might want to make certain fields relevant for specific locations:
LOCATION.NAME == "North Kivu"
Check for specific dates
START_DATE == DATE(2023, 1, 1)