# "Avg Cast" and "Avg Hit" columns don't sort correctly

**URL:** <https://forums.combatlogforums.com/t/avg-cast-and-avg-hit-columns-dont-sort-correctly/11692>\
**Category:** Warcraft Logs\
**Created:** [May 28, 2021, 11:58pm UTC](https://forums.combatlogforums.com/t/avg-cast-and-avg-hit-columns-dont-sort-correctly/11692 "2021-05-28T23:58:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jolvii](https://avatars.discourse-cdn.com/v4/letter/j/eb9ed0/32.png) [@Jolvii](https://forums.combatlogforums.com/u/Jolvii)\
**Post date:** [May 28, 2021, 11:58pm UTC](https://forums.combatlogforums.com/t/avg-cast-and-avg-hit-columns-dont-sort-correctly/11692/1 "2021-05-28T23:58:15Z")

</div>

Issue: I selected a specific character and the “Damage Done” tab. I sorted by “Avg Cast” but realised that values smaller than 1000 were being regarded as bigger than any value that had a “k” in it. The column seems to sort by ignoring the “k” as a thousand multiplier and merely considering the number before it:

 ![avgcast](https://canada1.discourse-cdn.com/flex029/uploads/combatlogforums/original/2X/8/8422d0aa5c9e847e242d554869e70c9912bdcfa9.png)

The same happens for “Avg Cast”. “Amount” seems to sort fine though, even with “k” or million multiplier “m”.