You could try making a new field to hold the scalar values and running a saved table to Table copy to copy the value of the formula query into the scalar field. It is possible that the table to table copy will time out and fail.
If it fails, you could have a pipeline which similarly would search for all of the records, which do not already have a scalar value and then in a for each loop it would update the scaler field. The pipeline might take a long time to run, but you could leave it run overnight.