Monday, January 21, 2019

totals calculating with rounding 2

new BigDecimal(FaTransDtl.sum('TransAmt') == null ? 0 : FaTransDtl.sum('TransAmt') ).setScale(2,BigDecimal.ROUND_HALF_EVEN)


If u want sum on same VO

object.getRowSet().sum('ExpnsAmt != null ? ExpnsAmt : 0 ')

https://adfindepth.blogspot.com/2019/01/groovy-examples-in-adf-column-sum-using.html

new BigDecimal(object.getRowSet().sum('DrcrTag=="D"?(TransAmt != null ? TransAmt : 0 ):0')).setScale(2, BigDecimal.ROUND_HALF_EVEN)

No comments:

Post a Comment