COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 29 Jun 2011 11:19:25 AM

Title: total of data item not visible
Post by: philelmousse on 29 Jun 2011 11:19:25 AM
Hello,

In my crosstab I have a dataitem as row with the total avec two members but nothing is visible... I dont understand
Title: Re: total of data item not visible
Post by: RobsWalker68 on 29 Jun 2011 12:43:51 PM
Hi,

How are you totalling the two members?

Is it something like:

1.aggregate(currentMeasure within set (set([memberA],[MemberB])) or

2. MemberA + MemberB

If it is option 2 is either of the members null as you may need to do a nullability test to sort that out.

Cheers

Rob
Title: Re: total of data item not visible
Post by: philelmousse on 29 Jun 2011 02:22:55 PM
thanks RobsWalker68, it works with the nullability test.