AnsweredAssumed Answered

Is it possible to calculate a field using another field that was created by an attribute expression in AGOL?

Question asked by sroberts_carltoncounty on Sep 12, 2018
Latest reply on Sep 18, 2018 by KGerrow-esristaff

I am creating an application at work to track mileage for our employees. I have created a web map containing a hosted line feature layer to track employees driving paths. I then created an attribute expression to calculate total distance in miles. Shown below: 

This calculation then automatically creates a field in my attribute table and names the field 'Custom', shown below:

What I would like to do now is take this 'custom' field and calculate the cost of mileage using the 2018 IRS Mileage Rate of $0.545 per mile. I have tried everything I could think of and CANNOT find a calculation that will work, especially considering that my 'custom' field doesn't show up as an option for use in a new calculation for an Attribute Expression. I have also attempted to create a new field called 'cost' and attempted to calculate the field using the 'custom' field but it also does not show up as an option to be used within a calculation. 

 

I am starting to think creating a new field based off of an attribute expression is not supported or pretty much impossible. Has anyone experienced this same issue? Or does anyone have any other ideas of another way I could calculate mileage and then cost?

 

Thanks!

Outcomes