BusinessObjects Board

How to substract 2 dimension objects from 2 different dps?

I am doing a report with some counts from 2 different years and each year is brought by different dp and i would like to substract. I know it is not possible or may be I am wrong.

Has anyone done something like this?

Thanks,

james.


Jamesp :us: (BOB member since 2004-10-13)

James, that should be possible. Have you tried and got an error? It may not work straight away, but try creating a new variable and giving it the formula something like:

<my_count_of_something_2005> - <my_count_of_something_2004>

…for example…


Nick Daniels :uk: (BOB member since 2002-08-15)

I tried running it but it gave me a DMB0008 error which is incompatible object error.


Jamesp :us: (BOB member since 2004-10-13)

Cool okay, we’re on the way. So these are two measures you are subtracting? Are your data providers linked at all?

See this for a bit of an explaination


Nick Daniels :uk: (BOB member since 2002-08-15)