Skip to Content
0
Aug 22, 2023 at 03:10 PM

Cube CDS - Aggregate Total Different Depending on Group By

267 Views Last edit Sep 06, 2023 at 08:02 AM 2 rev

Hi Folks,

I was wondering if someone can help me. I have am writing some CUBE CDS. The question I have, is that the total of a sum aggregate is different depending on the properties in the group by statement. So if I have 2 properties in the group by statement the aggregate value sums to lets say 100. But if I have 3 properties in the group by statement when calling the CDS the summation of the aggregate values is 150. I don't understand how this can happen. If anyone can help me here, I would really appreciate it.

Best regards,

Seamus