We have a hydrometer/sieve display that shows the data in a graph and has a 5 row table below that.
12 table columns. Last two are Silt (percent) and clay (percent).
The idea is to have silt percent/clay percent show as one value in the middle if the result is a p200 sieve analysis and silt/clay separated if the result is a hydro analysis. That part works great.
What doesn't work.
We have tried to put in a conditional table line separating silt/clay and have that line only show up if the result for that specific data row show up if that data row is a hydrometer.
The conditional line statement works if it's all hydrometer results or all normal sieve results. But if you combine hydro and sieve only results, the line is always there. The column line at any specific row has the following condition:
<<HasData(<<Interpolate(<<HYD READINGS.Percent_Finer>><<#>>,_ <<HYD READINGS.Particle_Size>> = _ <<User System Data.Silt_Clay_Boundary>>,A,L_ )>>_)>>
My assumption is that this will never work as the line drawings are not tied to a table so "#" is not interpreted for subsequent rows. Is there any way to make this work? And am I making sense?