We perform inspections, where uncorrected and corrected gas meter readings are obtained.
To verify the readings are accurate, a formula is manually performed:
((a - b) x pfactor) + c
- a = this month's uncorrected meter reading
- b = last month’s uncorrected meter reading
- pfactor = Positive Displacement Factor (a variable based on the pressure at the time of the inspection - a different number for every 0.5psi change in pressure)
- c = last month’s corrected meter reading
What’s the best way and location to perform this calculation automatically?
Thought about Survey123, but don’t have a way to bring in last month’s reading.
Thought about a Dashboard, but can’t do complex calculations like that in Enterprise Portal.
Thought about an arcade expression in a feature pop-up on a map, but would be very time consuming to click on each point inspected during the month to verify readings.
Suggestions?
%2520-%2520Copy.png)
