Thanks for the replies, I think I know what the issue is
Im using a switch in the Sort which takes the UpdateContext of the Sort Icon OnChange of varSortG1 and denote the value, which then assign the sorting column. All sorting columns are Text, except for the 'Contract Amount' one with the issue. But if I swap the 'Contract Amount' at 1st, the sorting works on the Digits without issues.
Sort(
Filter(
CurrentR,
Entity_x0020_Adjust_x0020_for_x0020_S_x0020_Branches= Entity.Text
&& Agreement_x0020_Type = Dropdown_AgreementType_PSA.SelectedText.Value
),
Switch(varSortG1,"AName",Agreement_x0020_Name,"LOB",LOB,"ANumber",Agreement_x0020_Number,"Account",Bill_x0020_to_x0020_Account_x0020_Name,"CAmount",Contract_x0020_Amount),
Switch(varSortOrder1,true,SortOrder.Descending,false,SortOrder.Ascending)
)
