Help needed on Smartforms- Table -Calculations Node

Former Member — Wed, 20 Sep 2006 08:34:01 GMT

Hi All,

I am new to smartforms. Can anyone tell me about the Calculations node in Table Element. If possible please share me some code samples.

Thanks,

Udaya.

PS: All helpful answers will be rewarded.

Re: Help needed on Smartforms- Table -Calculations Node

Former Member — Wed, 20 Sep 2006 08:40:22 GMT

Hi,

The calculation node allows you to do simple operations like Totalling of a field in the table.

For eg if you have a amount field in the table, and you want to sum that field for all the item's in the table then instead of writing a code for it, you can directly use the sum opearation in calculations.

Similarly u can use the operation Average(mean) and numbering in the table.

Regards,

Devendra

Re: Help needed on Smartforms- Table -Calculations Node

Former Member — Wed, 20 Sep 2006 08:41:24 GMT

Hi,

When executing calculations during table output, you must distinguish between two cases:

1)To calculate values that refer to a single unit or currency, use the Calculations tab of the table node. This node allows you to flexibly integrate the operations Total, Average Value and Number into your table output.

2)To calculate values whose results refer to different units or currencies, you must include program lines nodes in the navigation tree to execute the calculations manually

To use automatic calculations you proceed as follows:

1) Define an additional global field, the target field, which you need to display the result of the operation.

2) On the Calculations tab of the table node select an operation first, then a field (that is, a column of the table), for which to execute the operation, and specify the calculation and initialization events.

3) Depending on whether you execute a calculation on all items of the table or on items of a sort level, display your result either in the footer or at the beginning or end of a sort level.

See the below SAP link for Calculations:-

http://help.sap.com/saphelp_nw04/helpdata/en/cd/c8d11a356111d5b699006094192fe3/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cd/c8d114356111d5b699006094192fe3/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/cd/c8d11d356111d5b699006094192fe3/content.htm

Summing Up Different Currencies:-

http://help.sap.com/saphelp_nw04/helpdata/en/35/3f899ab4c111d4b62a006094192fe3/content.htm

Regards

Sudheer

topic Help needed on Smartforms- Table -Calculations Node in Application Development and Automation Discussions

Help needed on Smartforms- Table -Calculations Node

Re: Help needed on Smartforms- Table -Calculations Node

Re: Help needed on Smartforms- Table -Calculations Node