Straight table > total

[#1]

Hello QVer,

I have a straight table

A	B	C	D	E	F
ID	FAKA	FAKB	FAKA*FAKB	FAKA*FAKB / FAKB	WANTED
TOTAL	-	9	152,10	70,20	16,9 (=152,1/9)
ID1	24,40	1	24,40	24,40	24,40
ID2	19,80	3	59,40	19,80	19,80
ID3	14,10	4	56,40	14,10	14,10
ID4	11,90	1	11,90	11,90	11,90

and our users want the result of "field D/field C" in all rows - incl. total -; and not "sum of rows" as you see in

in field=E.

I did a lot of exercises to solve that but with no successfull outcome.

Do you see a workable solution? Is it possible with straight tabel?

Thank you an Greetings

dj_skbs

See also picture.

[#2]

check properties:

[#3]

Thank you.

I tried the proposal "Pari Pari" gave me but I got an empty total cell (field E) doing so:

A	B	C	D	E
ID	FAKA	FAKB	FAKA*FAKB	FAKA*FAKB/FAKB
	70,2	9	152,1	-
ID1	24,40	1	24,4	24,4
ID2	19,80	3	59,4	19,8
ID3	14,10	4	56,4	14,1
ID4	11,90	1	11,9	11,9

What's wrong? See example qvw attached.

dj_skbs

[#4]

it should be expression:

=sum(FAKA)*sum(FAKB)/sum(FAKB)

or

=sum(FAKA*FAKB/FAKB)

[brenner_martina · Accepted solution]

Hi, dj_skbs,

that's so easy, your expression must be:

Sum(FAKA*FAKB)/Sum(FAKB)

Greetings from Munich, Germany

Martina