1 Reply Latest reply on Feb 12, 2018 9:34 AM by Deepak Rai

# COUNT function giving different values depending on column

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
• ###### 1. Re: COUNT function giving different values depending on column

You need to Pivot your data to get This:

Thanks

Deepak