new BigDecimal(FaTransDtl.sum('TransAmt') == null ? 0 : FaTransDtl.sum('TransAmt') ).setScale(2,BigDecimal.ROUND_HALF_EVEN)
If u want sum on same VO
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