COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: benji41 on 10 Feb 2015 10:52:41 AM

Title: DMR calculation with other data value
Post by: benji41 on 10 Feb 2015 10:52:41 AM
Hello everybody,

I have a crosstab with a DMR calculation : plz see attached file

Réel A
total([Ca Total] within set [Calendaire A])

Réel A-1
total([Ca Total] within set [Calendaire A-1])

Réel A - A-1
total([Ca Total] within set [Calendaire A])  - total([Ca Total] within set [Calendaire A-1])

This works fine but I would like to add another value (I can retrieve this value from a table from another query)

Is it possible on this way ? 

If not, how can I do it ?

Thanks a lot