Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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() )