Using a formula to build a string

[petejigsaw]

I have been trying to use a formula to build a new string value on a report in CR2008.

The formula is:

if (Left ({prodmast.pm_unit_type},2 )="26") then "2'6 (76cm)" else
"NA"

However, while this works, I really need to add a " after the 2'6, so it reads 2'6". However, if I simply put one in, the formula doesn't then work as Crystal assumes the formula is incorrect.

Is there any way to get the formula to return the required value?

Any help much appreciated.

 

[briangriffin]

if (Left ({prodmast.pm_unit_type},2 )="26") then "2'6"" (76cm)" else
"NA"

 

[petejigsaw]

Thanks Brian - works a treat!