COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: stemann on 15 Dec 2015 01:54:14 PM

Title: The context for the arthmetic operator "/" is invalid. A numeric value is requir
Post by: stemann on 15 Dec 2015 01:54:14 PM
I am trying to get a % in a crosstab. I drop a query calculation into the crosstab as a column.

[OTD]/[Total(OTD)]

The context for the arthmetic operator "/" is invalid. is part of the error i get.

Title: Re: The context for the arthmetic operator "/" is invalid. A numeric value is requir
Post by: schrotty on 15 Dec 2015 09:03:25 PM
Hello Stemann,

do you have a relational model?
I suppose in your total expression the syntax is not correct.
Please try [OTD]/[Total([OTD])


schrotty