I feel like pulling my teeth out. My SUM calculation is wrong and I can not find a solution online. After making ATTR I got nearer but not near enough.
I need to sum all these orders for one person. The answer I get for the following is £3 360.00, and I do not know where it is coming from.
Please can anyone help. I have just isolated this one example. I use Desktop Tableau 9.3 and have included an extract.
Dec 22, 2016 5:54 AM
Hi Allen,
Your issue remains in your database. Each value is multiplied by the amount of entries (14).
Please check your model in the database
| 14 | 40 | 560 | |
| 14 | 40 | 560 | |
| 14 | -80 | -1120 | |
| 14 | 200 | 2800 | |
| 14 | 80 | 1120 | |
| 14 | -40 | -560 | |
| 3360 | |||
You are right there. I tried several things and did not work until I removed where 14 was coming from. The 14 was number of customer visits. removing from view did not help until I removed it from the data source.
Thanks for your help.