4 Replies Latest reply: Jul 20, 2012 5:59 AM by Martina Brenner

# Straight table > total

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

• ###### Re: Straight table > total

check properties:

• ###### Re: Straight table > total

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

• ###### Re: Straight table > total

it should be expression:

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

or

=sum(FAKA*FAKB/FAKB)

• ###### Re: Straight table > total

Hi, dj_skbs,

that's so easy, your expression must be:

Sum(FAKA*FAKB)/Sum(FAKB)

Greetings from Munich, Germany

Martina