Number Format issue in 2 dimension Block/Pie charts

[#1]

When I have a two dimension Block with a Num() in the expression, the top level numbers are not formatted, but the 2nd level numbers are formatted correctly.  When I convert the object to one dimension, the number formats are correct.

Does anyone know how to fix it for the Block Chart? 

John

[Anonymous]

Hi John,

Why don't you apply the appropriate rounding to the expression:

E.g.

= Num(

IF(vCurrencyType = 'USD',

  Round(Sum(SalesUSD)),

  IF(vCurrencyType = 'EUR',

   Round(Sum(SalesEUR))

   )

  ), '$(vCurrencyFormat)' )

Charlie

[#3]

That would handle the number of digits, but it would not put the currency symbol in front of the number.