Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
That would handle the number of digits, but it would not put the currency symbol in front of the number.