Hello!
I am building a fence report and I am trying to pull a depth from a table to use as the top depth to my vertical lines on a bar graph. The problem is that I cannot get the program to pull the minimum depth where there is data for the bar graph. I want to start the top of the vertical lines at 7, but everything I have put in just starts the lines at zero. How would I get this to work?
Thanks!
I knew it had to be simple. This worked. Thank you!!
Hi Erinn,
This is just very general you will need to modify to match your Table and field names.
Use the Min function with the optional Where clause in the top depth expression of the vertical line to Depth
I am assuming your field name is Recovery Length.
<<Min(<<YOUR TABLE NAME.Depth>>,<<YOUR TABLE NAME.Recovery Length>> = "True")>>
Answer Verified By: Kirk Johnson