Calculated fields: Aggregations

Sadly, SharePoint does not support aggregations based on the value of a numeric calculated field. The only workaround is to avoid the use of a calculated field and instead use an external system to set the value of the field.

An example of an external system which could be used to bridge this gap would be Power Automate. To complete ths functionality, create a new Flow which is triggered upon a List Item update or creation event. Then calculate the value, and save it to a new numeric field.