Report Issues

[AnkitaC]

Hi All,

I am facing a bit weird issue . I have a straight table and a measure like below

=Sum([Purchase Amount]).

when I export the straight table in excel, and take the sum of Amount from the excel rows , the total shown in Qlik does not match with the total shown in excel rows. 

Though the diff is very major, but still it exists. Could it be a number format issue?

I have set the amount expression fixed to #,##0.00 (done from the Number tab)

[Kayleigh_Milewski]

Hi,

Did you make sure that the 'Totals function' under the measure is set to 'Sum'?

[AnkitaC]

Hi,

Thanks for reply but actually i done that already after sum function now sum is correct but its not match with answer means when function is auto that time total is correct but extract that value from dashboard to excel sum is not matching but after change to sum function according to that sum is correct but total of this sum is not matching with our data

[AnkitaC]

Hi,

please help me solve this issue.