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?
You are almost there with your Output Condition, you just need to replace the Repeat character <<#>> in your expression with the Set Key number for each "set of data".
These all work the same, so you can select which format you prefer.
<<HYD READINGS.Percent_Finer>>1,_
<<HYD READINGS.Percent_Finer>>:1,_
<<HYD READINGS.Percent_Finer>>:[1},_For example:
This is the Output Condition that you need for the first row "vertical" line.
<<HasData(_ <<Interpolate(_ <<HYD READINGS.Percent_Finer>>1,_ <<HYD READINGS.Particle_Size>> = <<User System Data.Silt_Clay_Boundary>>,_ A,L_ )>>_)>>
This is the Output Condition that you need for the second row "vertical" line.
<<HasData(_ <<Interpolate(_ <<HYD READINGS.Percent_Finer>>2,_ <<HYD READINGS.Particle_Size>> = <<User System Data.Silt_Clay_Boundary>>,_ A,L_ )>>_)>>
This is the Output Condition that you need for the third row "vertical" line.
<<HasData(_ <<Interpolate(_ <<HYD READINGS.Percent_Finer>>3,_ <<HYD READINGS.Particle_Size>> = <<User System Data.Silt_Clay_Boundary>>,_ A,L_ )>>_)>>
This is the Output Condition that you need for the fourth row "vertical" line.
<<HasData(_ <<Interpolate(_ <<HYD READINGS.Percent_Finer>>4,_ <<HYD READINGS.Particle_Size>> = <<User System Data.Silt_Clay_Boundary>>,_ A,L_ )>>_)>>
This is the Output Condition that you need for the fifth row "vertical" line.
<<HasData(_ <<Interpolate(_ <<HYD READINGS.Percent_Finer>>5,_ <<HYD READINGS.Particle_Size>> = <<User System Data.Silt_Clay_Boundary>>,_ A,L_ )>>_)>>