Coding modulus (%)

[truenorth]

I am coding this in a rule logic:

Code: Select all

new_month = no_of_months % 12

In the list of functions, the modulo operator is listed as "%". But with code similar to the above, I am getting this error:

The variable "%" contains an invalid character.

Does anyone know how to code modulus?

[swapnilverma]

you can use div or mod functions to achive your desired results.

As per docs % is mainly used for date specification...

may be some one else can put some more light on this ....


but u can definatly use mod function .

[ray.wurlod]

There is no modulus operator in Information Analyzer rule definition expressions - you need to use the Mod() function as indicated.

[truenorth]

I coded

Code: Select all

mod(no_of_months,12)

and got the error "Mod is not a known scalar function."

[ray.wurlod]

Hmm. Use the functions list (one of the four tabs on the right hand side). You may need to subtract the integer value of the division from the division or some such.

[truenorth]

Yes, Ray, that's what I ended up doing. IBM should get their act together! And the list of functions is short. I hope they can add more. I can use add_months right now.

Thanks, all.