Subtract columns from each other

[AlanM]

Hello Guys,

the goal is to show the difference between column "IST" and "PLAN" in column "Abw.":

	IST	PLAN	Abw.	Abw. %
Umsatz	100 €	80 €	?	?
Kosten	80 €	70 €	?	?

„Abw.“ should be able to be filled with an expression like:

Column A - Column B

it is possible to subtract columns from each other?

"Abw. %“ should be able to be filled with an expression like:

(Column A - Column B) / Column A

it is possible to subtract and divide columns from each other?

If not, any other ideas?

Thanks in advance.

[AlanM]

Hello Guys,

the goal is to show the difference between column "IST" and "PLAN" in column "Abw.":

	IST	PLAN	Abw.	Abw. %
Umsatz	100 €	80 €	?	?
Kosten	80 €	70 €	?	?

„Abw.“ should be able to be filled with an expression like:

Column A - Column B

it is possible to subtract columns from each other?

"Abw. %“ should be able to be filled with an expression like:

(Column A - Column B) / Column A

it is possible to subtract and divide columns from each other?

If not, any other ideas?

Thanks in advance.

[agigliotti]

Yes you can do it using column label or column number.

ex.  Abw.  =  IST - PLAN
or
Column(1) - Column(2)

I hope it can helps.

[Taoufiq_Zarra · Accepted solution]

if these are measures, we can use the Column function
as the attached example

[AlanM]

Many thanks for the quick help. Worked great!!

[AlanM]

Hello,

when Sum(IST) and Sum(PLAN) not a measure  but a dimension. Is there also a formula?

Thanks in advance.

[Nils9]

I am also looking for a way to calculate two dimensions. have you found the solution?