Skip to Content
0
Former Member
May 13, 2010 at 10:35 AM

CO-PA column formula in report painter

981 Views

Hi all,

Sorry about previously explanation!

In KE34, when define a form, we need several columns with a formula that is a combination between cells.

Rows:

- Row 1: Revenue (Y001)

- Row 2: Total cost (Y002)

- Row 3: Wages cost (Y003)

- Row 4: Depreciation cost (Y004)

- Row 5: ...

Columns:

- Column 1: Plan - value (X001)

- column 2: Plan - % (X002)= Cost / revenue * 100

for example: Cell Z001 (interaction between row 2 and column 2) = Y002/Y001 * 100%

Cell Z002 (interaction between row 3 and column 2) = Y003/Y001 * 100%

How I can set formula for column 2?

I tried to define formula for each cell in column 2. It worked, but it takes too much time cause the report includes 3 column like column 2; and about 20 rows -> 3*20 cells need to define for each report like this???

Is there any tool or formula variable i should use instead?

Thanks for any help

HuyenTT

Edited by: huyentt4 on May 17, 2010 11:22 AM