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

mod() finction throws an error in Conditional Stlye

Started by hrjanardhan, 27 May 2016 12:47:00 AM

Previous topic - Next topic

hrjanardhan

Using Cognos 10.2.2. I'm trying to achieve alternate row color by using mod(RowNumber(), 2) = 0. But it throws this error.
RSV-VAL-0034 Failed to validate variable Conditional Style 1
CRX-YXX-4010 Parsing error.

While I have used the same logic successfully in other of my reports, I am getting this error in some of the reports.

Mfg

QuoteUsing Cognos 10.2.2. I'm trying to achieve alternate row color by using mod(RowNumber(), 2) = 0. But it throws this error.
RSV-VAL-0034 Failed to validate variable Conditional Style 1
CRX-YXX-4010 Parsing error.

While I have used the same logic successfully in other of my reports, I am getting this error in some of the reports.

if i am not wrong try to put the expression in a data item(say MOD) and add it to the property of the data container(Say List) you are using or add it to the property of a data item(if you are using crosstab).Drag the data item to the variable expression definition instead of giving the whole expression in the variable itself.
MFG

hrjanardhan

Using the mod function itself throws an error wherever I use it.

MFGF

Quote from: hrjanardhan on 27 Jun 2016 11:49:00 PM
Using the mod function itself throws an error wherever I use it.

Is the issue where you use mod() - a Cognos function - with Rownumber()? Have you tried replacing Rownumber() with a running-count?

MF.
Meep!