NS concat formula with colour

replace(

   ns_concat(

       ‘<font color=”darkgreen”>’ || {billingtransaction} || ‘</font>’ || 

       ‘ –>’ || 

       ‘[ <font color=”red”>’ || ABS({billingtransaction.quantity}) || ‘</font> ]’ || 

       ‘–>’ || 

       ‘<font color=”blue”>’ || {billingtransaction.line} || ‘</font>’

   ), 

   ‘,’, 

   ‘<br>’

)

Leave a comment

Your email address will not be published. Required fields are marked *