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

BEX Query not returning fields if there are null values


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?