Thanks for your quick reponse.
I used table box and cross checked the numbers already. For some reason the numbers are not matching with raw data. I am also aware of the suppress options. I have not done any thing like that.
Moreover as I said this mismatch is occuring even when i am trying to get the numbers plainly without any function. Hence there is no fear of supress conditons also.
I think it is difficult to share the problem properly here. Let me know if its possible to call you on lync or skype so that I can share my screen with you and get your help asap. Its quite urgent.
My email ID: firstname.lastname@example.org
Thanks in advance.
Thanks for your response. Please find attached the sample app. I am also attaching the raw data file that is being fetched to get the numbers. I have highlighted the 4 columns In raw data that are used in my sample app in yellow.
You can see that the numbers are off from the raw data even though the filters are properly used. Let me know if you need anything else.
please find the sample raw data for the default filters of the sample app. Due to security reasons I don't have permission to attach excel file.
Let me know if this helps.
Date Country Business Group Customer Segment Device Type Ref Store Catalogue Visits Item Removal Pre_PS_Search Post_PS_Search 10/1/2012 GLOBAL-WW All All All All 532787872 529922816 429691904 685602688
Yeah, I had been going through it. But nothing such issues found. Let's try to figure it out step by step.
First load a single field where you see the discrepancies, say Pre_PS_Search alone and take a note of data.
Load with the entire SQL part and note the same field data.
Load the entire script(with second table) and note the data.
Then please let know your observation.