Expression?

[#1]

Hi!

I've got a Straight Table that looks something like this;

Customer	Invoiced value	Andel fakturerat	TB	TB Andel	TB%
Total	3 000 000	15%	500 000		16,6%
A	1 000 000	5%	200 000	15%	5%
B	1 000 000	5%	200 000		5%
C	500 000	2,5%	50 000		3,3%
D	500 000	2,5%	50 000		3,3%

and what I want to do, is to divide the total Invoiced value with TB for each row. For example;

3 000 000/200 000 = TB Andel (=15) for Customer A.

Is it possible to do this in an Expression?

I hope you understand the weird explanation! Thank you!

[srchilukoori]

you can use

=column(1)/column(3)

as the expression for column(4), i.e., TD Andel

[Anonymous]

try this

=sum(TB)/sum(total Invoiced value)

[its_anandrjs]

You can write

=Sum( ALL  [Invoiced Value]) / Sum(TB)

for each row in the table

[cfz]

Hi Jonathan,

Try

sum(TB)/(sum(TOTAL [Invoiced value])

This should solve the problem.

Regards

Carlos

[its_anandrjs]

You can also write it different ways also for TB Andel like

=(sum(ALL [Invoiced value]) / sum(TB)) & '%'

[#7]

sum(ALL [Invoiced value]) / sum(TB)