Static functions

[Former Member]

Hi,

How will use the static (Sum, Avg, Count) functions.

Thanks & Regards

Koteswara Rao

[Former Member]

Hi

These functions are designed for source fields that occur more than once in the source structure (maxOccurs = i > 1).

sum

R = Sum of values X1 to Xi of a context

average

R = Average of values X1 to Xi of a context

count

R = Number of fields in a context

As explained above...

See more details

http://help.sap.com/saphelp_erp2005vp/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.htm

Regards

Chilla..

[Former Member]

Hey

static functions in addition to the input and output values also require the context(their position in the XML tree)

thanx

ahmad

[Former Member]

Sorry i am not clear with u r explanation please explane me with an example.

[prabhu_s2]

<b>Count & Sum</b>

Say ur source strucutre is like this:

<root>

<line>

<record num>1</record num>

<record num>2/record num>

<record num>3/record num>

<record num>4/record num>

</ine>

mapping line->count->target field will fetch the number of item present in the node line....sum work in the same fashion. This is simple but some times we cannot use these f/s's with count/sum/avg...in those case we gofor context change