Why does the calculation result change?

Hello,

Could you please attach screenshot from the last calculation? I've done it in PQL and everything seems to be fine.

It was done in SQL?

Best Regards,

Mateusz Dudek

Hello.

Thank you for answering.

I uploaded a screenshot.

It was done in SQL?

>>>Yes

What's wrong?

Push, I have the same problem, see:

https://www.celopeers.com/s/question/0D50700000lQKMECA4/individually-the-dividend-and-divisor-are-correct-but-when-the-quotient-is-calculated-the-result-is-wrong

Hi, Ino Steinke

The same thing is happening...

If you find a solution, please let me know.

Hello.

Thank you for answering.

I uploaded a screenshot.

It was done in SQL?

>>>Yes

What's wrong?

Hello @ryotaro.manab 

sorry for late reply - it's probably underlying grouping problem.

F.e. if one sum is taking amounts from document level, and the second from document item level aditional calulation steps can be done in the background. I would using numbers having same "level" of data, it can be done by using domain table or PU functions. If mixed "levels" of data are used (SUM on document level, divided by SUM of item level) results can be strange as one of SUM statement will be automatically grouped again.

Additional note: screenshot seems to be PQL editor, so issue was located in the front-end. It's important because it affect the causes of the problem and available ways of solving it.

Hope that helps :)

Best Regards,

Mateusz Dudek