Originally posted by: SystemAdmin

Have a rule with a COUNT from 1 - 99. On rare occassions, the count will be greater than 99 and the overflow will put ## in the output field. Is there a way to reset the count to 0 on an overflow condition and start the count anew? Would an IF statement be capable of testing the output object and reseting the count to 0 within the same rule?

I am trying to avoid enlarging the output field because it is used in dozens of subsequent jobs which would also have to be altered.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

number overruns can be managed like this with the MOD function. If you want to limit your output to two digits ( 0-99 ), use 100 as the divisor.

mod(0,100)=0
mod(199,100)=99
mod(101,100)=1

so you might try something like
=MOD(COUNT(a),100)

Regards,

Karl
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange