3 Replies Latest reply: Jan 31, 2014 7:34 AM by Sara Titmuss RSS

    Format text into Money

    Sara Titmuss



      I have the following expression in a text object:


      =round(sum(TARGET)) which returns 349520169.  As I want the total of all targets


      However, I want this shown as £349,520,169.00.  I have tried the functions tab and can't seem to get to grips with it.  Can anyone help??