Different sum Values using subquery instead of view

1

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

image
image1767×616 49.1 KB

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

image
image1498×571 23.5 KB

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

2

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)

3

@ASchmidt

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