Syntax for percentage

[Desperado]

Hi ,
This is my query to display the values in percentage. is there any wrong in the syntax..

IF ([DS].[DIM].[PERCENT_FLAG]='Y')
THEN (round([DS].[PKG_1].[BU2],[DS].[DIM].[PRECISION])*100)
ELSE
(round([DS].[PKG_1].[BU2],[DS].[DIM].[PRECISION]))

Thanks in Advance

[sir_jeroen]

What's going wrong?

[mikegreen]

Hi ,
This is my query to display the values in percentage. is there any wrong in the syntax..

IF ([DS].[DIM].[PERCENT_FLAG]='Y')
THEN (round([DS].[PKG_1].[BU2],[DS].[DIM].[PRECISION])*100)
ELSE
(round([DS].[PKG_1].[BU2],[DS].[DIM].[PRECISION]))

Thanks in Advance

Why not just click on your data item, then "data format" and choose percentage. It'll do that for you.

You can make it apply certain formatting based on data elements using conditional formatting.

Cheers

Mike

[bdybldr]

Have you tried using a static value instead of "[DS].[DIM].[PRECISION]" just to see if it works?