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

DMR calculation with other data value

Started by benji41, 10 Feb 2015 10:52:41 AM

Previous topic - Next topic

benji41

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