Why a calculation in the report dont give the same result in the load script

[bentley32]

Hello all 🙂

I am trying to do a simple calculation 

=sum(x)/sum(y)

when i do it in the report i got a good results but when i do it in the load script like with aggregations, it doesnt work at all, iv got wrong numbers, i do aggregation on the load script on the lowest level

Thanks

[Or]

I don't understand what you're trying to achieve here if you want to do this in script. If you want to pre-calculate the value for each annee_pec and mois_pec , you should only have those in the group by clause, not the entire field list. It's hard to imagine a scenario where a simple sum like this should take a long time at the front-end level, though, so I don't really know why you'd have performance issues doing it front-side.

[bentley32]

I have 30 calculated measure for each month of transaction  enc01 enc02

and since its cumulated, which one is reading from the last one

this is why i wanted to help a little bit with this simple division on load script

if im not doing it in columns i will have 500M rows ...