Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sum(SUM_QTY*UNIT_WEIGHT)
Don't leave fields outside the aggregation...
when use this Sum(SUM_QTY*UNIT_WEIGHT) I get big number
any update
please help me
Not sure what update you're expecting. Your issue is that your weight field is outside the aggregation, which means that if there are multiple unit weights (as is the case in a total row), it breaks. You need to move it inside the aggregation. If you get a result that is different from the one you expect, there may be something wrong with your data model, but since you haven't specified anything regarding that, it's impossible to say.