collapsed rows do not sum the present values ?

[#1]

HelloTogehter,

can someone explain me why the collapsed rows in this case do not sum the existing 3 values ?

status expanded row:

status collapsed row:

I had expected that the 3 values ​​in the expanded rows [0,00 € +0.00 € + €20,253.88] are summed in the collapsed row.  Instead of the expected value of 20.253.88 € . 

An example of qvw file is attached. Thank you for any help.

Best Regards,

[swuehl · Accepted solution]

You probably need to use an aggregation function, like

=sum(PD_AGGREGATED_WERT)

insetad of just using the Fieldname

=PD_AGGREGATED_WERT

which is ambiguous if you collapse the rows.

Hope this helps,

Stefan

[#3]

Hi Stefan,

not really

Unfortunately i didnt understand your response. Should the collapse action of the shown row not to sum all included

underrows to one value ?

Thank you for your advice

Best Regards,

Hon

[#4]

Hi Stefan,

sorry I've mistaken for the problem. It works!

Thank you very much