Forum Post: RE: How can we use total function in HTML report

[Sudhakar]

Hi @Gian Torralba, when over there is change in AD Today column values then at the bottom total should calculate by taking those values. Im using expression as below in referral source if("{!status#code}"=="ACT") // if Referral source Status=Active { #CALC_COUNT.R101162498( 1 | createdAt =TODAY) //count the no of "actions done"(related object to referral source) } And in HTML report im using as below td width="5%" align="center" #EVAL[rbv_api.selectNumber("SELECT SUM(ad_today) FROM referral_source");] /td Kindly let me know what i need to do to get dynamic total values at the bottom

Continue reading...