Originally posted by: SystemAdmin

I have 2 repeated groups where I want to count the number of occurances and also the size of the 2 groups

I am usind the COUNT function COUNT( grp1) + COUNT( grp2) but I am unable to get the output.I am able to get the output only when I am COUNTING for one single group..IF I am doing it for two groups at a time i am getting the output as "ZERO" IF I am doing for one group then I am getting the result..The same case with SIZE too..
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: jvanboga

try :

sum (COUNT( grp1) + COUNT( grp2) )
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Staar

It might be evaluating to NONE because one of the groups is not present. If you just do Count(Grp1) + Count(Grp2) and Grp1 or Grp2 evaluates to None then the whole thing will evaluate as None.

Try: IF(PRESENT(Grp1),COUNT(Grp1),0) + IF(PRESENT(Grp2),COUNT(Grp2),0)
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender