Forum Discussion
Missing Sum Icon in the table
Hi, For some reason, I lost the Icon of sum in my tables for all numeric fields. This is how it was before: Any idea how to fix it? Thanks!
Hi Anonymous ,
The icon in front of fields with numeric type appears when the option Summarization under Column tools tab is set as any of aggregations(Sum/Average/Minimum/Maximum/Count/Count (Distinct) ). When it set to Don't summarize, the icon will be disappear... Please check whether the Summarization of these numeric fields also be set to Don't summarize.
Best Regards
amitchandak
Super User
Super UserAnonymous , Go to Power Query/ Transform Data.
Under Transform Data Table, There is an option detect data type. Click that for the table and save and exit and try
The data types are correct.
It didn't work.