Values doubling up in the sum

[#1]

Hi all,

I have a strange one here.

I'm using a cross table to transform values into the format I need, so that I can get correct Months.

Then I'm using this table(Resident), to create my final results.

See my attached example, with the comparison of the Raw Cross table results and the final table.

Some values are being doubled twice for 1 month(When summed in a straigh table), and can't see the reason behind this?

Any ideas would be appreciated.

Cheers.

[udit_kumar_sana · Accepted solution]

Hi ,

Please find here the attached file for your issue.

Try to do the distinct at script level to the Raw Cross table & final Table..

I have done here at expression level ,since i can't reload your file.

Regards,

Udit