Hello everyone.

I´m new in OS and I have a doubt:

In aggregates, when I want to compute something like the total amount of an Entity for each month, what should I do first? Compute the new attribute (sum the amounts) and then do the Group by month or first do the Group by month and then compute new attribute. I did the test and both return the same results.


Thanks in advance.

Best Regards,

Ana Nunes

In the case you describe the generated SQL would be the same, so order of operations when using the aggregate shouldn't matter.

Ana Nunes wrote:

Hello everyone.

I´m new in OS and I have a doubt:

In aggregates, when I want to compute something like the total amount of an Entity for each month, what should I do first? Compute the new attribute (sum the amounts) and then do the Group by month or first do the Group by month and then compute new attribute. I did the test and both return the same results.


Thanks in advance.

Best Regards,

Ana Nunes


Hi Ana Nunes,

Yes both are the same.

Different approaches, same results.... :)

You are doing same with different approaches.