Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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 ...