Wrong 'Group by' data result in HANA view

[Former Member]

Hello,

How can this be possible?

In the first SQL selection screen the result for TENDERAMOUNT should be equal to 492.5

As you can see, in the second selection, when I added TRANSNUMBER on the selection group the values changed and the sum is 492.5.

hana-view.jpg

Thank you for any help I can get

BR

[Former Member]

Just one more information

This view loads from another view, "OPER_GENERIC" and in that view we have calculated columns like so:

When I add this to the selection it bewaves as it should! This "Exception Aggregation Type" = "COUNT_DISTINCT" is somehow selecting it right. So, I asked end users to add this field to the report, but they don't want to. 😞

Is the lake of this in the selection responsible for the wrong figures?

Thank you!

[Former Member]

Thank you!

Sure, here it is

view-properties.png

view-fields.png

[former_member492332]

Hi Paulo,

group-by-result.jpg

I tried creating the data for similar scenario and group by works fine for both kind of SQL queries.

Could you please provide the table/view definition of all fields on which you are writing the query.