Conditional % Format

[basquiat]

Hi

I've got a report with a formula field;
Depending on the paramater selected by the user, the field should be displayed either as a number or as a %;

Is there an easier way of doing this apart from adding another formula field with a % format and suppressing the fields based on the paramater selected?;

Thanks

 

[dgillz]

Rt click the field and select format field. Customize the display to enable currency symbol, use % as the currency symbol, and make it a trailing currency symbol.

Finally, hit the X-2 button to the right of the currency symbol and enter a formula:

if {?Parm}="Pct" then "%" else ""

Replace the first part of the formula above with the proper test for the parameter value you are using.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Madawc]

If there were more than one formula fields with this problem, it would make sense to create a formula field with dgillz's test and include it with the values that might or might not per percentage.

Madawc Williams (East Anglia, UK)

 

[basquiat]

Thank you very much!