Spotfire Ideas Portal
It is difficult handling null values when aggregating values within custom expressions because a single null values will cause the expression to evaluate as null.
I (and others) often use logic like this:
AggregationFunction( if([value] is not null, [value], "") )
This can lead to very complex expressions, especially when the value above is also an expression. It would be much nicer to have a NVL expression so the above function could be:
AggregationFunction( NVL([value,"") ).
Ah! Somehow I had never found that function!
Yes, we can close this request. Thanks
Is this not just using the SN([value],"") to change a NULL to a value?