Skip to Content
0
Former Member
Sep 12, 2011 at 12:37 PM

Use Result of other column in new Formulacolumn

17 Views

Hallo,

this is difficult to describe, so read carefully 😊

  • column A shows revenue [per region] in total

  • column B shows the same keyfigure as A, but I am using "Calculate Single result as %"

  • Now I can see the revenue in total and in % [per region]

  • column C shows my costs in total

  • column D: formula: C * B

When calculating column D, column B is read. Tecnically column B is a total value, but using "Calculate Single result as %" it shows %. Unfortunately column D takes the total value of column B and not %.

What can I do to read the %-value in my formula instead of the total value?

Any hints are welcome,

Christian