Different sum Values using subquery instead of view

Hey, i have a view AllOrders which returns 116€ as profit if i run it as subquery:

But if i use the view itself i get -372€ as profit.

I deleted the reflection so that is not the problem.

Anybody with an idea why this happens?

If i open both outputs as csv in excel and do a autosum on “Gewinn” i get 116 in both tables o.0

Can be closed, i fixed it.

Problem was i added some floats together to generate “Profit” which made it as a datatype that SUM couldn’t compute.
So i casted “Profit” as float and now its working (Y)


Would you be able to send us both job profiles to compare and see where the issue is?