7 Replies Latest reply: Aug 24, 2016 2:00 AM by Isar Klinikum

# subtotal in a table with one dimension

Hello everybody,

I have a table with one dimension. I now want to make the sum of the lines above in column 5 at defined totals rows. The column 5 adapts automatically when you enter into the InputFields changes. The problem is however that do not adapt the sums in the sum line the new values. With Rangesum I've tried it, but because the problem is that it continues to calculate the subtotal down and thus the wrong result is obtained. Does somebody has any idea? I've attached a sample file.

• ###### Re: subtotal in a table with one dimension

Hello Isar, I am not sure if this is the case but can you try and let us know by changing your expression like below:

In your second expression try like this:

Expr: Lineare Hochrechnung auf das Jahr

= column(1)/ (6 * 12)

Or

= Column(1)/72

• ###### Re: subtotal in a table with one dimension

Hi Vish,

thanks for yout help! Do you have an idea, how to get the correct Sum in Row Nr. 11 (yellow) in column 5? This must be the sum of the rows before.

King regards!

• ###### Re: subtotal in a table with one dimension

Hi,

first of all i'd change your first expression to:

=SUM(Saldo)

what your are doing with set analysis is the default QV behavior in this case (i've tried and gives the exact same result).

And regarding your issue i would recommend what Vish said,

=Column(1) / (6*12)

Remember that parenthesis are used in mathematical expressions to denote modifications to normal order of operations (precedence rules). If you want QV to evaluate your expression with another order then you must add them, if you dont then QV will process your operation with maths default order for operations.

Let me know if this helps.

Kind regards,

• ###### Re: subtotal in a table with one dimension

Hi,

thanks for your help! In Column Nr. 2 (Lineare Hochrechnung auf das Jahr) I tried the Expression column(1)/6*12. My Problem is in the last column Nr. 5 (Lineare Hochrechnung mit Variablen). In this column you will see the results of column(2) + column(4). It works, but I have no idea how to get the subtotal in the yellow Row Nr. 11 in column 5. This must be the sum of the rows before.

• ###### Re: subtotal in a table with one dimension

Try this in your last expression i.e, 5th Column and see if it is coming out correct :

= IF(Left(Rubrik,2) = '11', RangeSum(Above([Lineare Hochrechnung auf das Jahr] + [Veränderung],0, 11)), [Lineare Hochrechnung auf das Jahr] + [Veränderung])

• ###### Re: subtotal in a table with one dimension

Hi Vish,

thank you very much, it works! :-)

Best wishes from Munich!

• ###### Re: subtotal in a table with one dimension

Hi!

What would be the field for totaling? I dont know if i follow but check this and tell if it helps.

Added a calculated dimension in order to have something to group by and total.

Kind regards,