I have some difficult to show soil description for each sample in Sample Table from Lithology Table. Here are what I did:
<<Sql(SELECT (LITHOLOGY.DESCRIPTION) _ FROM LITHOLOGY _ WHERE (<<Sample.Depth>> < <<Lithology.Bottom>>) AND _ (<<Sample.depth…
The general rule for rounding '5' my company uses is to round to the closest even number.
ie 99.5 = 100 or 98.5 = 98
2.405 = 2.40 or 1.395 = 1.40
It appears that gINT always rounds '5' up.
The only formulas I have been able to find even…