Skip to Content
0
Former Member
Nov 24, 2008 at 06:06 PM

useOneAsMany

60 Views

Hi,

In my Message Mapping, I have a situation where in I have to add all occurrence of A's based on unique occurrence of B's. For example in the structure has A= 1,3,5,6,4 for B='abc' and A= 8,9,10 for B='cba' then I need to get the values 19 for the first 5A's and 27 for the last B's as output. I am using use one as many in this case but getting the the total 19+27=46 for all A's and B's.

Please can you suggest some tips or UDF's. UDF where a function like 'on change' may help.....

Thanks in Advance

Manohar