Values doubling up in the sum

Mon, 18 Mar 2013 10:42:26 GMT

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.

Re: Values doubling up in the sum

udit_kumar_sana — Mon, 18 Mar 2013 12:41:52 GMT

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