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

How to use MOD

Started by lifzgud, 03 Sep 2009 11:33:15 PM

Previous topic - Next topic

lifzgud

Can anybody please tell me how to use MOD in cognos report studio expression

blom0344

mod([someindex],2)

yields:

index      result
1           1
2           0
3           1
4           0
5           1
..
..
117        1
118        0

Get the picture?

lifzgud

Yes i have tried this but it throws up an error when i run the report

Naven

Hi,

We have used mod function to show alternate backgorund colors in HTML(list/crosstab) formats.

Expression is  mod(runningcount(),2)  ,  this is defined in boolean variable and list body is rendered accordingly.

Regards,
Naveen

lifzgud

I'm sorry...i messed up the date part in the mod..its working...  thanks guys
Cheers:)