Calculation on the values from a single column in Web Intelligence(BOBI 4.3) report

[vishal_p3]

Hello Experts,

I am developing a Webi report(4.3 SP3) and generating a cross table with 3 Dimensions at rows and 3 Dims at column(one of the Dim is BEx Structure) and one measure value in the body.

I need to generate a new column beside the cross table which has the calculation done on the values from the cross table. Please suggest on how to perform this. 

Thanks

[jaggu556]

Hi Vishal,

I guess we can add new column by inserting a column to right and apply the caculation on the formula editor.

To provide accurate answer, could you provide sample data with expected results 

Thanks.
Jagadeesh C

[vishal_p3]

Hi Jagadeesh,

Thank you for the reply! 

Please find the sample cross table below. 

And yes the requirement is to create a new block/column beside the crosstab with a function which should calculate =((C4*D4)-1)*100 and continued till the end of the column.

Thanks

[vishal_p3]

Hi All,

Please comment if you have any thoughts on this.

Thanks