Skip to Content
0
Former Member
Jul 05, 2006 at 07:13 PM

Formulas and Structure

25 Views

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.