COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: benji41 on 23 Apr 2015 08:23:18 AM

Title: Replace MISSING VALUE on DMR report
Post by: benji41 on 23 Apr 2015 08:23:18 AM
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