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