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

    Format text into Money

    Sara Titmuss

      Hi,

       

      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??

       

      Thanks.