Data variance in Qlikview

[#1]

Hi,

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)])

[Anonymous]

Hi,

Share your application with current month data in scrambled format. It is difficult to investigate this without having application in hand.

Thanks