JR30306 Member

Comments

  • Try this....as a starting point. You can use the HTML color coding (or not) to your liking. CONCAT('<p style="color: green">','$',concat(round((sum(`JUNE_ACV`)-sum(`MAY_ACV`))/1000,0),',',round(abs(mod(sum(`JUNE_ACV`)-sum(`MAY_ACV`),1000)),0)),'</p') BUT...when the result of the absolute value of the modulus is <100, this…