Hello,
I want to show only 2 decimals in the WL elevation. I tried to use the format command:
<<format(<<HasData(<<calc(<<POINT.Elevation>> - <<WATER LEVELS.DEPTH>>/3.28)>>,<<calc(<<POINT.Elevation>> - <<WATER LEVELS.DEPTH>>/3.28)>> m, "N/A")>>, 0.0)>>
Can anyone correct what would be the correct expression to show 2 decimals?
Please refer to the attached file.PDF
The format spec needs quotes. Not sure how the format spec will respond to a non-numeric value (NA) when there is no water level reading. Thus, a better formulation of this would be:
<<HasData(<<Calc(<<WATER LEVELS.DEPTH>> AND <<POINT.Elevation>>)>>,<<Format(<<Calc(<<POINT.Elevation>>-<<WATER LEVELS.DEPTH>>/3.28)>>,"0.00")>> m,"NA")>>
Note that this assumes your water depth is in feet and your elevation is in meters. Also assumes that you want to display NA if there is no water reading or no elevation (ie both have to be present before calculating, formatting and labeling the water level elevation).