Friday, March 27, 2009

Conditional formatting





1st image : Schema Work bench – Where I specified the formatstring
2nd Image : My output in the BI Server - In that many characters are discarded in the output eg . - dot ,> - greater than symbol


format string not working
My formatstring is :
Iif(([Measures].[SalesAmount]/[Measures].[InternetOrderCount])>40,"|$#,##0.00|style='red'","|$#,##0.00|style='green'")

No comments:

Post a Comment