PLD: profit & loss statement: how to add a field percentage(%)

[Former Member]

Hello,

is there anyone updated the profit & loss statement (PLD) with a new column %, it's equal to

line amount / total sales amount * 100%

I tried, but the difficult is to get the amount of "Total Sales" (F_096) for its system variable in repetitive area. I did:

a new field: F_114 --- formula === Substring (F_096,11) = 'Total SALES'

a new field: F_115 --- link to F_114, formula ==== F_083

Anywhere wrong in the setting above?

Will be very appreciated for your help.

~Michelle

[Former Member]

cancel.

[former_member206488]

Hi,

You have P L statement in crystal report?

maill me the report.

regards,

Neetu

[Former Member]

TO SAP developer:

Finally I use Crystal report to rebuild Profit & Loss Statement (Income Statement) to satisfy company's requirement:

1. Show 2 Percentage column per Sales Amount for both Period Turn and YTD .

2. Not show Negative on non income account in the P&L statement report.

3. Add blank line after each "Total" row

4. Shorten the report pages

BR,

Michelle