I noticed some variances in my source data against Qlik's, Qlik is wrong, but only for selected few, most of the others are okay, and best of all, the total aggreated total is correct........really puzzling.
Below snapshot, top is customer's current month sales total, and the bottom table is from the source data in MS Access for same month & year. Any advice? Thank you.
Formula is : sum([ACTUAL_SALES_AMT(JPY)])