Filter with formulas

[beatrizmguerreiro]

Hello, 

I have a group of condtions that have to be met. In the end, I only want to have the results with "True" value. 

I am using the FILTER tool. E.g.: 

ISNULL([Field 1])

OR

ISNULL([Field 2])

OR

ISNULL([Field 3])

However, there also conditions as follows:

- Validate if the month in date (Column name: Date 1; format: DD/MM/YYYY) is matching the Month (Column name: Date 2; format: MM)

- Validate if the ISO country code (Column name: ISO) matches the Country name (Country).

Can also have this in the FILTER tool- That way, in the end, I can only retrieve the True values. Or is it required to have a FORMULA tool? 

[beatrizmguerreiro]

Cool. Thanks! 

Another question that pop-up. Still within the FILTER tool:

If I want to validate a calculation. E.g:

FIELD1: 3

FIELD2: 2

TOTAL: 5 (= 3 + 2)

How can I add this? 

[marcusblackhill]

You can add a simple math like ([field 1] + [field 2]) = [field 3], if you need to add that check to the older formula, add " and ([field1] + [field2]) = [TOTAL]".