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

[Anonymous]

Sunil,

You can keep the format part separately:

num(
if(),  your expression based on conditions
if()  formatting based on conditions
)

In general, I'd rather have several conditional text boxes, each formatted for its currency, and show one on another depending on currency.

Regards,
Michael