Set Analysis return 0 value even if there is no value

[#1]

Hi all,

I have an expression with set analysis and it works perfectly fine: The set check the calendar and return the latest value according to the selections.

The issue start when I move my calendar to a period in the past where there are no value for that metric. It should return me a null but it return me a 0.

Summarizing the expression go against a non existing record and return a 0 instead of a null.

Can you help me with this?

tks,

fb

[swuehl]

I believe this is QV standard behaviour and I personally don't see anything wrong with it.

If you absolutely want NULL returned, you might be able to check the number of records, like

=if( Count( {<SetExpression>} ID), Sum({<SetExpression>} IDValue), NULL() )