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

How can I show null values?????????????????????

Started by mayocraze, 11 May 2011 05:14:16 AM

Previous topic - Next topic

mayocraze

I've created a report which has [account number] & [processing amount], however all those accounts without processing amount are suppressed automatically.

I tryed to create a outer join relation, but it doesnt work...The null value rows are still not showing...

Anybody can help here? (I wont be able to adjust the FM model, so prefer some solution within rs itself)

blom0344

You can relatively easily solve this with a union

union1:  [account_number]     [processing amount]

union2:  [account_number]     0

Use the result set in the report (make sure you total the measure) and group by account_number.

The result will show ALL account_numbers, with 0 where no processing amount exists