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?
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 WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Phil,
That worked perfectly, at least so far. I must get familiar with the lookup function.