Sub Totals in PLD

[Former Member]

Hi,

Can any one tell how can i calculated the sub totals regarding a column in PLD

Thanks & Regards

Ravi.K

Functional Consultant for SAP B1

New Horizons Cybersoft Ltd.

Hyd, AP, India.

[Former Member · Accepted solution]

In the repetitive area footer, insert a new Formula Column and use the formula "Colsum(Field_Name)" to get the column total.

[Former Member · Accepted solution]

Hi Sridharan,

Thanks for ur reply.

But, i am not talking about column sum but sub total in the same column for Ex: in repetitive area consisting of 10 lines in print out, i want sub total of first 4 rows and sub total of 5th row to 10th row.

[Former Member · Accepted solution]

To do so, you have to enable 'Type' Column for the documents through 'Formsettings'.

Now after adding few rows in the document you can add a new row with type as 'Subtotal' so the screen would display the sub total.

Now preview this with SAP Default PLD, this would display with the SubTotal within repetitive area.

Hope you understood.

[Former Member · Accepted solution]

Hi Sridharan,

Thanks for ur reply.

I want sub total in BRS. In BRS we have no option to make sub total in the report.

Thanks

Ravi.K

[gagan_thareja · Accepted solution]

Hi,

I have taked an example of sales quotation here. Request you to please

follow the following steps in case you are using A cluster of Business one:

In addition to field "Field_025" which is part of the Systemtemplate,

and located in the Repetitive Area, add the following fields to the

template.

Create following field on PAGE HEADER

1. Field_Datafield1

General Tab

Left = 0 / Width = 0 / Top = 0 / Height = 0

Content Tab

Source Type = Database

Table = Sales Quotation

Column = Document Currency

Create following fields in REPETITIVE AREA

2. Field_Datafield 2

GENERAL TAB

Left = 0 / Width = 0 / Top = 0 / Height = 0

CONTENT TAB

Source Type = Database

Table = Sales Quotation-Rows

Column = Row Type

3. Field_Textfield 1

GENERAL TAB

Left = 0 / Width = 0 / Top = 0 / Height = 0

CONTENT TAB

Source Type = Free Text

(empty)

4. Field_Formula1

GENERAL TAB

Left = 0 / Width = 0 / Top = 0 / Height = 0

CONTENT TAB

Source Type = Formula

Field_Datafield 2 != Field_Textfield 1

5. Field_Formula2

GENERAL TAB

locate directly above field "Field_025"

Link to =Field_Datafield 2

CONTENT TAB

Source Type = Formula

Concat(Amount(Field_025)," ",Field_Datafield1)

6. Field_025

ID = Field_025

Link to = Field_Formula1

Hope this will help.

Regards,

Gagan Thareja

[Former Member]

Please follow this procedure:

To define sub-totals do the following:
a. In the Repetitive Area Footer create a Formula field.
b. Choose the Formula Editor pushbutton and select the operand ColSum(UniqueID as String) in the Operation field (for the Quantity field from the rows in the Sales Quotation).
The field within the brackets defines the column for which a total will be calculated. You can also calculate totals for the Price and Total columns.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Thanks for ur reply.

But, i am not talking about column sum but sub total in the same column for Ex: in repetitive area consisting of 10 lines in print out, i want sub total of first 4 rows and sub total of 5th row to 10th row.

Thanks

Ravi.K