I have a Weighted Overlay raster which contains surface friction values in the VALUE field. I want to apply a formula to convert friction value to speed. How do I select a field in the layer so it will do it for all 45 values in the layer?
Raster Layer Name: WO_equal_2
Field in layer to use: VALUE
Data range in Value is from: 150 to 1000
Formula used in Raster Calculator: Speed - ((Value/1000)*40) (equation works in Excel)
WO_equal_2 has an attribute table with three fields: OBJECTID*, Value, Count
Result is a new Raster layer with only two values. Seems to only read first row and applies formula to both Value and Count field.
Going back to olden days (Pre ArcGIS 10) we had dot command to do this in Raster Calculator.
I have tried this in three versions of ArcGIS desktop (10.1, 10.3, and 10.5)
Any and all suggestions to an easy solution welcome.