2 of 2 people found this helpful
In your datasource, you've joined the Customer and agentdispo tables together.
If you only use Customer, then weizheng_teng = 1366
When you join on to agentdispo, weizheng_teng = 1,019,036
a multiple of 746 (which I've verified in the data)
so using a SUM is doing the right thing, and all the other maths functions are working as well
3 of 3 people found this helpful
This is almost certainly caused by your join. Shouldn't you be joining on the day / date field as well?
Oh! Gosh u guys figured out really fast. Silly me.
I tried to connect the date fields of both sheets but the result is still not correct.
What are the fields that I should be connecting to resolve this issue?
Opps nvm! I got it. Had to use right connect instead of inner. Many thanks guys!