Skip to Content
0
Former Member
Jun 22, 2016 at 11:13 PM

BEX Query not returning fields if there are null values

283 Views

I have a query that does not return an entire field if the values are NULL. I've tried several calculated Key Figures based on Condition Value:


0 + <your_original_key_figure>

(Value > 0 )* Value + NOT (Values >0) * 0

I've made sure Zero Value display --- select : Zero without currency.

Any advice to get the field to come through even if all values are Null?