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
since the integer value is converted to text using ToText() the integer results are appended with .00
ToText (x, y) where y is a whole number indicating the number of decimal places to carry the value in x to.