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

Replace MISSING VALUE on DMR report

Started by benji41, 23 Apr 2015 08:23:18 AM

Previous topic - Next topic

benji41

Dear all,

I'm trying to make a total like this on my DMR report

total ([Comptage Inter (sum)]  within set [Client absent] )

It works fine

But depending datas, I have no result for this total because there are no date retrieve

So, I try to make calculation for example : total ([Comptage Inter (sum)]  within set [Client absent] ) + 2000
but report studio can't add no existing data to 2000

I try nvl function but don't work