Actually, you can simplify this even further by using the format of the field to include the '%' instead of converting to text. So, here's your formula:
If not IsNull({@TotalSampleByComponent}) and {@TotalSampleByComponent}) > 0 then
{@TotalFailed}%{@TotalSampleByComponent}
else 0
NOTE: I added the "If" statement to prevent division by zero errors that will cause the report to fail.
Once you add this to the report, right click on it and select "Format Field...". On the Number tab, click on the "Customize" button. On the new Number tab, select the correct decimals and rounding. Then go to the "Currency Symbol" tab. Enable the currency symbol and set its position to be on the right. Then set the actual symbol to "%". This will give you the format you're looking for without having to convert the number to text.
-Dell
IP Logged
