Formulas and Structure

[Former Member]

Hi,

I am having some problems using formulas. My report uses a structure (A = BCD+E).

For example, the result of the report is:

Var % = ((Value 2 / Value 1) - 1) * 100

Struct Value 1 Value 2 Var %

A 155.377,32 18.386,92 42,38

-- B 0,00 0,00 0,00

-- C 4.847,45 13.295,59 174,28

-- D 146.029,87 2.091,33 -98,57

-- E 4.500,00 3.000,00 -33,33

The problem is that the Var % of row A is calculated by adding the others Var % (row B, C, D and E). "42,38 = 0,00 + 174,28 + (-98,57) + (-33,33)"

I need to have the calculation of Var % (A) being made by the formula ((Value 2 / Value 1) - 1) * 100 and not adding this sub-Values.

Could anyone please help me?

Thanks.

[former_member188975 · Accepted solution]

Hi Luiz,

Please try setting the Formula Collision property of this formula that can be found at the bottom of the screen when you right click > properties.

http://help.sap.com/saphelp_nw04/helpdata/en/d2/02223c5f00612be10000000a11402f/content.htm

Hope this helps...