Problem with aggregation

Question

Hello,

Question here.  I have combinated analysis like this.  I have formula in yellow  '(Sprz netto * 100/Sprzedaż netto dyn YA)-100'. As you see everything it's good.

But not in result:

I tried to do it with different aggregation in result: sum and other on cryteria. I don't have any idea, every column in this report works fine (default aggregation) without this.

Cryteria

Smakosh · Answer

No, null is in the second part of the UNION. Yes I tried to switch two request (and the same situation) and I must use UNION because in the second request i must do quantinty for different period then in the first query.

So, I do sum in another analysis and join everyting on Information desk. That left me.

FTisiot · Answer

UNION and aggregate calculations are always a problem because you can't really setup a proper aggregation formula... Is the column  NULL in the first part of the UNION and filled with the formula in the second?

Have you tried switching the two request (putting the second as first)?

Are you forced to use the UNION is there any way that you can avoid that?