BEX Query not returning fields if there are null values

[Former Member]

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?

[Former Member]

If your field is part of Structure or Key Figure, select properties --> Display and use Suppress Zero option.