remove first brackets on concatenated expression

[rustyfishbones]

Hi All,

I have the following expression, which I use in the extension called MinimalistHTMLTextBox. This extension acts like a marque and moves the text from left to right on the screen.

='<marquee behavior="scroll" direction="left"><font color="$(color.kpi.headline)">'

&

Concat(DISTINCT If(Len(Trim(Aggr($(e.charge-amount), CUSTOMER))) > 0, CUSTOMER & ' - ')

& Num(Aggr($(e.charge-amount), CUSTOMER), '£#,##0') &

'<font color="RGB(170,0,0)">' & ' ('  & Num((Aggr($(e.charge-amount), CUSTOMER)/SUM(TOTAL [charge-amount])),'0.00%') & ')'  & '</font>'

, '<font color="black">' & ' , ' & '</font>' , -Aggr($(e.charge-amount), CUSTOMER))

The result works fine, however I always have blank brackets at the start of the string and I want to remove these

Whats the best way of removing these?

Regards

Alan

[sunny_talwar]

Or that

[rustyfishbones]

Thanks Sunny.