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

Calculation problem difference variable style

Started by bartburg, 12 May 2020 04:48:37 AM

Previous topic - Next topic

bartburg

Hi guys and girls,

I hope u can help me out with this report question that i have. If iam not clear or u have questions do ask.

Let begin:
first off i need to show a picture bases on wether a calculation is going up or down monthly.

To start lets say i have columns A and B that have values and a month shown as below

A   B   Month
Xx   Xx   1
Xx   Xx   2
Xx   Xx   3
Xx   Xx   4
Xx   Xx   5
Xx   Xx   6
Xx   Xx   7
Xx   Xx   8
Xx   Xx   9
Xx   Xx   10
Xx   Xx   11
Xx   Xx   12

Now i calculate de moving total for both A and  B in MTA and MTB
example(moving-total([a]; 12))

A   B   Month   MTA   MTB
Xx   Xx   1          Xx     Xx
Xx   Xx   2        Xx   Xx
Xx   Xx   3        Xx   Xx
Xx   Xx   4        Xx   Xx
Xx   Xx   5        Xx   Xx
Xx   Xx   6   Xx   Xx
Xx   Xx   7   Xx   Xx
Xx   Xx   8   Xx   Xx
Xx   Xx   9   Xx   Xx
Xx   Xx   10   Xx   Xx
Xx   Xx   11   Xx   Xx
Xx   Xx   12   xx   Xx

Now i only need the last month for just the main page but also want month 11 for diff
I use: (month is normaly dynamic but fort his example i simplify it a bit)
case when month = 12
then MTA/MTB*100
Else null
end
As TMonth
And
case when month = 11
then MTA/MTB*100
Else null
end
As LMonth

So now u have this
A   B   Month   MTA   MTB   TMonth   LMonth
Xx   Xx   1   Xx   Xx   Null   Null
Xx   Xx   2   Xx   Xx   Null   Null
Xx   Xx   3   Xx   Xx   Null   Null
Xx   Xx   4   Xx   Xx   Null   Null
Xx   Xx   5   Xx   Xx   Null   Null
Xx   Xx   6   Xx   Xx   Null   Null
Xx   Xx   7   Xx   Xx   Null   Null
Xx   Xx   8   Xx   Xx   Null   Null
Xx   Xx   9   Xx   Xx   Null   Null
Xx   Xx   10   Xx   Xx   Null   Null
Xx   Xx   11   Xx   Xx   Null   6,89
Xx   Xx   12   xx   Xx   5,77   Null

Now i want to do something variable like TMonth > LMonth but when i do it does not work i cant get cognos to see that TMonth is 5,77 and LMonth is 6,89 in a variable style.

Do u guys have any suggestions in how to do this?

If u have any questions plz ask

Thanks
Bart