EQUAL (==)


The EQUAL (==) operators tests whether two values are equal.


a == b


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".


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:


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)
Next item