Smartform : Totalu00F6s and subtotals

[Former Member]

Hello All,

I have created a smartform with the data as per the requirement.

Everything is fine..But now I want the totals and subtotals of my data in this.

Can anyone help me in acheiving this ?

Regards,

Deepu.K

[jayanthi_jayaraman · Accepted solution]

Hi,

You can do it using calculations tab.Refer standard programs sf_example_01 and sf_example_02.

[Former Member]

Hello,

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.

Regards,

Shehryar

[Former Member]

Hello Guys,

Thanks to all of you for ur prompt replies.

I'll try to implement as per ur advice and get back to u in case of any issues.

Regards,

Deepu.K

[raguraman_c]

Hi,

Smartforms makes you feel at ease. It provides automatic totalling.

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.

Check out this Help link. Quite exhaustive. But you have very good examples provided.

Feel free to revert Back.

--Ragu

[Former Member]

Hello,

Are u using a table ??

Regards,

Shehryar