I am facing an issue while I need to increase number of decimal places of list calculative column. I need it in SharePoint online - unfortunately the list contains more than 40K records (and increasing). As the list contains huge records, I get the error message "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator." - when I go to change the decimal places from 2 to 3 and save the column edit option.
Obviously - the threshold issue is preventing me to modify the column settings but getting no point to do this. For List views I have optimized column with indices and filter - so I can manage views as my needs. for this modification of column settings getting no clue.
Appreciate in advance!