Assuming you are counting/summing up values, you could use Null() function in the expression to eliminate null values. This would even work with the text box.
It could be something like this
=count(if(Dimesnion<>'',Value)) or =count(if(Dimesnion<>Null(),Value))
Is that what you are looking for?
no, i think i originally asked the wrong question..
i want to encorporate the 2 expressions together..
IF(iv_fiscal_year = $(vCurrentYearFiscal),$(vTargetSum_Volume))
I have tried
it_target_type='Volume',iv_fiscal_year = $(vCurrentYearFiscal),$(vTargetSum_Volume))
but i get the same value as just using the first expression on its own.