Set analysis: unexpected results when filtering on null field

arturomiquelveyrat — Wed, 23 Jul 2025 14:48:52 GMT

Problem description

I'm trying to use Set Analysis to filter data. The expression is:

Sum({<Flag = {1}>} Amount)

If field Flag is not always null, the result is as expected: only records with Flag = 1 are included. However, if Flag is always null, all records are included.

Although it might not be a bug, I'm sure this is not what users expect of Set Analysis.

Examples

1. Flag not always null - Correct behaviour

Data and results:

Flag	Amount
	10
1	20
	30

2. Flag is always null - Incorrect behaviour