Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Sum({1-< _Field1= {'*'} >} Amount )
Great, thanks. I actually need some other statements in the set expression as well, so this was great.
Thanks for this answer also.