i want to return a text or a number based on a field value in crystal report
local numberVar i;
i:=Roundup(({@a}/{@b})*100,0);
if{@a}=0 then ToText('N/A') else ToText(i);
the result is always this in crystal report
- test_colum
- N/A
- N/a
- 2.00
- 3.00
since the integer value is converted to text using ToText() the integer results are appended with .00