1 Reply Latest reply: Jun 13, 2013 8:38 AM by Michael Solomovich RSS

    Formatting in a text box when using variable

    Sunil Kenth

      Hi

       

      I have a variable that am using in a text box.  I would like to format the number in the text but not sure where i should use the num function.  This is the expression in the variable:

       

      =

      if(only(CCY_2) = 'GBP',

      sum(RevenueDailyGBP),

      if(only(CCY_2) = 'USD',

      sum(RevenueDailyUSD), sum(RevenueDailyGBP)

      ))

       

      This is what i have tried to modify it to but it doenst work:

       

      =

      if(only(CCY_2) = 'GBP',

       

      num(sum(RevenueDailyGBP),'#,##0'),

       

      if(only(CCY_2) = 'USD',

       

      num(sum(RevenueDailyUSD),'#,##0'), num(sum(RevenueDailyGBP),'#,##0')

       

      ))

       

      Any ideas how i can do this?

       

      Thanks,

       

      Sunil