If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Addition

Started by deepak2k2, 09 Nov 2010 11:02:04 PM

Previous topic - Next topic

deepak2k2

Hi,

I want a add 3 data items in my crosstab.  But one of the Dataitem value contains 'NA' character.  If I add those 3 dataitems, i'm getting the result as 'NA'.

I've used the Exp as  DataItem1+DataItem2+DataItem3

How do I get the total value? (10+NA+8=18).  But I'm geting the result as NA.

blom0344

The solution would depend on the origin of the 'NA'. Why are 'NA' (Not Available) values returned? If you can fix this in the query that fetches the data and make sure a zero is returned instead, then the addition would be okay without additional work..

cognos10

You can format that data item N/A as '0' and then u can add all the data items