Using sieve readings in summary graphic table

I created a summary graphic table that references multiple lab data tables. One of the columns is:

<<IIf(<<SV READINGS.Reading>><=0.075,<<SV READINGS.Percent_Finer>>%)>>

"Dependent data" is checked.

However, I get a row for every sieve reading, even if it's blank. How do I get only the rows that I want?

Parents
  • Try

    <<DelimitData(,<<Lookup(<<SV READINGS.Percent_Finer>>,<<SV READINGS.Reading>> = 0.075)>>,%)>>

    Note you would need a space before the "<=", but i think you just want the percent fines so "=" should be used

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

Reply
  • Try

    <<DelimitData(,<<Lookup(<<SV READINGS.Percent_Finer>>,<<SV READINGS.Reading>> = 0.075)>>,%)>>

    Note you would need a space before the "<=", but i think you just want the percent fines so "=" should be used

    Phil Wade
    Datgel
    Bentley Channel Partner and Developer Partner
    E: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780

    Get the most out of gINT with Datgel Tools.

Children