![]() We get the annoying Count of Sales below: This usually happens when you download data from your ERP or external system and it throws in numbers that are formatted as text e.g. Pretty stupid but that’s the way it thinks.Īlso if you have a cell that is formatted as Text within your Values column, then it will also cause it to Count rather than Sum. So if you have at least one blank cell in a Values column, Excel automatically thinks that the whole column is text-based. A Values field is Grouped within your Table. There are “text” cells in your values column within your data set orģ. There are blank cells in your values column within your data set orĢ. ![]() Well, there are three reasons why this is the case.ġ. ![]() The no1 complaint that I get is “Why do my values show as a Count of rather than a Sumof ?”
0 Comments
Leave a Reply. |