<div>
Becuase {Clients.Units} is a number, the &quot;else&quot; clause must also return a number.<br />
<br />
If you are trying to suppress this field if zero, you should use a number format instead.<br />
<br />
Place the {Clients.Units} on the report, right click and select Format Field<br />
Click on the number tab and then customize button.<br />
<br />
put a Check in suppress if zero.<br />
<br />

</div>


Becuase {Clients.Units} is a number, the "else" clause must also return a number.

If you are trying to suppress this field if zero, you should use a number format instead.

Place the {Clients.Units} on the report, right click and select Format Field
Click on the number tab and then customize button.

put a Check in suppress if zero.



<div>
<div class="content wysiwyg-content">
Hi, I'm trying to construct a very simple formula in Crystal Reports that will only display the value if it is greater than zero. This is the formula I have: -<br />
If {Client.Units} &lt;&gt;&nbsp;0 then {Clients.Units} else &quot;&quot;<br />
I get 'A number is required here' error.<br />
Have tried this too: -<br />
If {Clients.Units} = 0 then &quot;&quot;&nbsp;else {Clients.Units}<br />
For this I get a 'String is Required Here' error!<br />
I'm sure this is very simple to resolve but I'm relatively new to Crystal and any help would be greatly appreciated.<br />
Thanks in advance.
</div>
</div>


Hi, I'm trying to construct a very simple formula in Crystal Reports that will only display the value if it is greater than zero. This is the formula I have: -
If {Client.Units} <> 0 then {Clients.Units} else ""
I get 'A number is required here' error.
Have tried this too: -
If {Clients.Units} = 0 then "" else {Clients.Units}
For this I get a 'String is Required Here' error!
I'm sure this is very simple to resolve but I'm relatively new to Crystal and any help would be greatly appreciated.
Thanks in advance.

Crystal Reports Formula Error 'A Number is Required Here'

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.