Hi everyone,
New to the community and I am having what could very well be a simple issue but I cannot get my head around it.
When calculating averages using Tableau instead of excel there were discrepancies. To check these out I created a small Tableau file that just sums up all the values in each column. Unfortunately, the sums do not match what is expected for all except one column so I decided to see if Tableau was reading in the correct number of rows by doing the same thing but instead counting the number of rows in each column. To my surprise the COUNT function returned different values for each column although the number of rows in each is the same and the data is pre-cleaned to not contain any null or blank values.
Below is an Excel pivot table of what the data should look like and attached is the Tableau file that I am having issues with.
Any help is greatly appreciated as I cannot understand why some columns are summed/counted correctly but others are not.
Thank you
Row Labels | Sum of Bid Price | Sum of Total Accepted Bid Volume | Sum of Offer Price | Sum of Total Accepted Offer Volume | Sum of FPN Volume |
05/02/2018 | 17301.27 | -14127.822 | 16001.18 | 6453.308 | 933951.446 |
06/02/2018 | 17379.14 | -13371.523 | 13545.79 | 6539.141 | 946389.389 |
07/02/2018 | 22956.69 | -20014.318 | 20495.37 | 11194.376 | 934715.728 |
08/02/2018 | 26197.6 | -31541.566 | 17445.69 | 18241.04 | 919262.531 |
09/02/2018 | 15643.65 | -9773.608 | 28536.42 | 12754.358 | 863263.105 |
10/02/2018 | -5274.38 | -31720.146 | 28040.8 | 30872.633 | 792169.887 |
11/02/2018 | 12441.52 | -16497.698 | 19413.72 | 17485.001 | 735468.37 |
(blank) | |||||
Grand Total | 106645.49 | -137046.681 | 143478.97 | 103539.857 | 6125220.456 |