I met a problem to round he calculated N60 value to only two decimals in a designed report. The value was calculated from the following code (yellow color) in the user system data in Data Design. I tried format function as guided in the gINT but it doesn't work. Could anyone help me with this issue?
<<Let(Refusal Pen = <<User System Data.Refusal Penetration>>)>>_<<ListBuildSepTrim(_ -,_ <<SAMPLE.Blows 1st>>,_ <<SAMPLE.Blows 2nd>>,_ <<SAMPLE.Blows 3rd>>,_ <<SAMPLE.Blows 4th>>_)>>_<<HasData(<<Get(Refusal Pen)>>,_ /<<Get(Refusal Pen)>>",_ <<DelimitData(_ <<cr>>(,_ <<Calc(<<SAMPLE.Blows 2nd>> + <<SAMPLE.Blows 3rd>>)>>,_ ) [_<<Calc((<<SAMPLE.Blows 2nd>> + <<SAMPLE.Blows 3rd>>) * <<POINT.Automatic Hammer Efficiency>> / 60)>>,_ )>>_ ]_)>>
Replace the yellow code with:
<<Format(<<Calc((<<SAMPLE.Blows 2nd>> + <<SAMPLE.Blows 3rd>>) * <<POINT.Automatic Hammer Efficiency>> / 60)>>,0.00)>>,_
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.
Answer Verified By: Shuo Yang
It works, thank you!