Handling nulls in matrix sub totals

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew Murphy - 31 Jul 2006 17:47 GMT

I have a matrix where I am using the inscope function to return different
calculations depending on which group it is in (ie the detail is just the
value and the sub totals are sum(values)).

In for the subtotal group I have used:

iif(isnothing(sum(Fields!CurrentCount.Value)), 0,
sum(Fields!CurrentCount.Value)

But this is still returning blanks where there are no values in the group to
sum together.

Can anyone suggest how to get around this issue as it ?

TIA

Andrew

Reply to this Message

Ben Watts - 31 Jul 2006 19:01 GMT

you might try iif(sum(Fields!CurrentCount.Value = nothing)

>I have a matrix where I am using the inscope function to return different
> calculations depending on which group it is in (ie the detail is just the
[quoted text clipped - 14 lines]
>
> Andrew

Reply to this Message

Ben Watts - 31 Jul 2006 19:09 GMT

also if this formula you put on here looks just like the one you have in the
expression then you need to add a perenthesis onto the end. I tried to
recreate your problem and I get a 0. Weird

>I have a matrix where I am using the inscope function to return different
> calculations depending on which group it is in (ie the detail is just the
[quoted text clipped - 14 lines]
>
> Andrew

Reply to this Message

Ben Watts - 31 Jul 2006 19:11 GMT

and aslo maybe you should try to set the null value to 0 before you sum it.

>I have a matrix where I am using the inscope function to return different
> calculations depending on which group it is in (ie the detail is just the
[quoted text clipped - 14 lines]
>
> Andrew

Reply to this Message