Добрый день!
Возможно ли задать формулу для отдельной ячейки в Report Painter для вычисления значения на основе рядом стоящих ячеек ?

Подобный вопрос более подробно задавали на другом форуме, к сожалению, остался без ответа.


Hi Report Painter Gurus,

I've defined a report using the Report Painter. This report uses formulas in the rows as well as in some columns and that leads to wrong results in the cells where a row formula crosses a column formula.

The following example shows what my report displays:
Row3 = Row2 / Row1*100
Column 3 = col.1 + col. 2

.........................................Col. 1.....Col.2.....Col.3
#1 PE.................................80...........40.........120
#2 Commissions.................20...........10..........30
#3 Commissions in % PE.....25%........25%......50%

The value "50%" in the cell row3/col3 is wrong! it should be 25%.
It seems that the column formula takes priority to the row formula: the report only calculates the sum of col.1 + col.2. I'd like the report to calculate row2/row1*100 also in the column 3 and display "25%" instead of "50%".

Do somebody know how to do this?
Can I give the priority to the row formula? If so, where can I do this?

(For your information: my report contains about 20 rows using characteristics + a formula refering to the row #1 for each of this 20 rows)

Тоже очень интересует...

В 4.6 сталкивался с такой проблемой, давно это было... Думаю в 7.0 можно подломить через точки расширения и написать свой расширяемый набор формул.