Hello, I've got a field (let´s call it _Field1) that only contains the value '1' for some of the records in the table.
I would like to create a set expression where I get the sum of all records with null() in _Field1.
Does anyone have a solution? I tried
Sum({$< _Field1-= {1} >} Amount)
but that doesn´t seem to work as long as _Field1 only contains null() for the rest of the records.
The table lookes something like this
| Dimension1 | _Field1 | Amount |
|---|
| Sales | 1 | 10 |
| Sales | | 20 |
| Sales | 1 | 30 |
| Sales | | 40 |
| Sales | 1 | 50 |
I wan´t the sum of Sales to be 60 (20+40)
