Remove "0" from Empty Line

[bwisealiahmad]

Hi,

I have a table that has some IF statements I am trying to remove because it loads quite slow sometimes. On lines that are emtpy a "0" comes up and I am trying to remove this. Right now the expressions is:

IF(

Report = Test

IF($(ReportName)_blankrow = 1, ' ', Sum(Expression))

Which produces something like this:

Now if I remove the _blankrow check part it looks like this.

Does anyone have a good suggestion for making it look like the first without using an IF statement in the front end?

Thanks,

Ali

[bwisealiahmad]

That changed the numbers quite a bit. What about putting the set analysis into variables? Any point?

[sunny_talwar]

Is Report an island field? Not sure if variable would make any difference

[bwisealiahmad]

It is...doesn't this make it a single threaded process then?

[sunny_talwar]

Don't know the details related to single threaded vs multiple threaded. But, island field dimension cannot work as set analysis. You will have to use it as a if statement only.