I run jet report and result does not correct. And I run again without changing any filter or function, the result change the right answer suddenly. I cannot find the error.
I extract the report which is items sale and remaining quantity for each vendors for shopping mall retail sales. No error showing and jet formula I wrote is correct. When I run the report, the result is not showing true quantity. So I re-run or I make drill-down, the result which I cursor changes to true quantity without rewrite any jet formula. This is happening for some items not all items. How can I solve it?
Thanks;
This is the the formula for my report. Data Source is big.
In first picture, I run to get item sale quantity but the result does not correct. In second picture, I run again putting cursor on that excel cell and get correct answer without changing any filter or function. This is happening the whole report.