I am building a survey to record flow measurements for surface water. A user will read a staff gauge in a stream. This reading will then be entered into an equation specific to that stream to convert the reading into a flow expressed in cubic feet per second. I was hoping I could set this up as follows (but it doesn't work, but hopefully illustrates what I am trying to do):
The specific formula in the calculation field is thus pulled from a csv table called "RatingTableInfo" which looks as follows:
The results, when set up as shown above looks like this:
In other words, it just shows the first two numbers of the equation, rather than the result of the equation. Is there a way to set this up so it actually does the math?
Any suggestion is appreciated. My alternative thought is to build extensive lookup tables where for each equation I provide all the possible results of the equation, rather than the equation itself and then use the pulldata function against those tables. However, there are dozens of equations and that seems quite a bit more cumbersome.