I have a plot vs depth for shear strength and would like to include the correlation to shear strength from an SPT N-value. Is there a way to suppress the result if say the lithology symbol/classification = or("XX", "YY", ...)? or some similar expression?
The post here has a duscusion on how to do this. It offers 5 different methods and discusses advantages and disadvantages.
communities.bentley.com/.../dependant-columns-in-log-template
If you only have one column and not a lot if data you can simply place an expression in the suppress body data output property similar to
<<Calc(_
<<lithology.symbol>> In ("xx","yy","zz")_
)>>
I do not have gINT available to me right now so have not tested the above. I am sure I don't have the syntax right but basically all you need is an expression that evaluates to true for the condition that you want to suppress.
I can provide more info and an example in a few days if you want. In that case it would be helpful if you provided a specific example including a sample output, a picture of the data used to generate it and any relevant data tables, and a picture of the entity tab you want to modify.
Thank you for your response. First i will start with a few examples of what i have tried so far. Everything has been attempted within the "output condition" section of the plot vs depth properties:
1)
<<IIf( _ <<Lithology.Depth>> >= <<SAMPLE.Depth>> And <<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> And _ <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _ <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _ <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _ <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _ <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _)>>
2)
<<IIf( _ <<Calc( <<Lithology.Depth>> >= <<SAMPLE.Depth>> )>> And <<Calc(<<SAMPLE.Depth>> >= <<Lithology.Bottom DEPTH>> )>> And _ <<LITHOLOGY.CLASSIFICATION>> = "CL" Or _ <<LITHOLOGY.CLASSIFICATION>> = "CH" Or _ <<LITHOLOGY.CLASSIFICATION>> = "CLS" Or _ <<LITHOLOGY.CLASSIFICATION>> = "Pt" Or _ <<LITHOLOGY.CLASSIFICATION>> = "OH", True, False _)>>
3)
<<IIf(<<LITHOLOGY.CLASSIFICATION>> = "CL" Or "CH" Or "CLS" Or "Pt" Or "OH", True, False )>>
So far either nothing plots or everything plots. Below you will see a screenshot of the report with all the data (nothing suppressed):
the image quality is bad, but the third plot is the SPT N-value versus depth. on the second plot i have included a crude estimate of the shear strength based on the N-value, however, i wish to only include this estimate if the strata is cohesive ("CL" Or "CH" Or "CLS" Or "Pt" Or "OH", etc.).
The simplest thing i can think of is to check the lithology at that depth. so for example, in the plot above, i would like to suppress the "shear strength" estimate from the N-value for the first and third layers (MLS and SM).
hope this helps, and that i made my question a bit clearer. Please let me know if you need any additional information.
I just want to add, that i did read the linked post and tried some of the SQLRange() options and other methods, but could not get it to work.
I also noticed one of my conditional statements in the post above may have an error when checking the depth, but i have fixed that, and still cannot obtain the outputs i am trying to achieve.