Print Page - Cell based Calculation (Crosstab)

Title: Cell based Calculation (Crosstab)
Post by: Chamopak on 20 Jun 2019 07:05:52 AM

Hi,

A crosstab was created with some cost centers and a basic calculation.
How can you make a calculation be different for a single cell based on the Row item criteria?

for example the row item j-e-0, instead of getting the Calculation 1 / Calculation 2 it will get (Calculation 1 / Calculation 2
)*-1

Thank you for your help

Title: Re: Cell based Calculation (Crosstab)
Post by: oscarca on 08 Jul 2019 02:49:14 AM

Would this work?:

case
when [Amount] = 'j-e-0' then (Calculation 1 / Calculation 2
)*-1
else
Calculation 1 / Calculation 2
end

Best regards,
Oscar

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Chamopak on 20 Jun 2019 07:05:52 AM