You’re right Ken,
That field although it is a decimal it appears as a string.
I have read that post Wappler return DECIMAL as TEXT and remembered that now you mention it…
I tried setting the Sort on to sorton="ord_Total.toNumber()" but no luck…
Unfortunately, in my case I cannot easily modify my server action because it is a complex one (paged query with a few joins(inner & left) and 2 level of nested subqueries and all of these with a complicated set of conditions based on $_GET parameters…)
So, there is no way of getting a proper sum on queries decimal columns?
Please somebody drop an idea here and save me from making all this ServerAction from scratch…