How to round off a number and display as text?

[cheerfulskeptic]

Hello,
I have the following formula:

if {#rTotal} >0 then ToText (Truncate ({#rTotalComplete}%{#rTotal}, 1)) else "N/A"

the object is to print out a percentage (to 1 decimal place) or else print "N/A".
I tried Round and Truncate, but it doesnt work.
Any ideas?
Thanks

 

[dgillz]

Why must you convert to text? How about this formula:

if {#rTotal}<>0 then Round({#rTotalComplete}%{#rTotal}, 1)) else 0

Then just format this as a percentage.



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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[cheerfulskeptic]

The requiremetns for the report state that there should be an &quot;N/A&quot; printed if the first variable (rTotal) is zero.

 

[cazellnu]

Maybe you can try to use If {#rTotal} >0 then ToText(Truncate{#rTotalComplete}%{#rTotal}, 1), 0) else &quot;N/A&quot;. Hope it can help.

 

[Ngolem]

I would do it a bit different

if {#rTotal} <> 0 then //it could be negative and still valid

ToText(round({#rTotalComplete}/{#rTotal}*100, 1),1)
else
&quot;N/A&quot;;

The only thing you have not explained is the format of this items

{#rTotal} and {#rTotalComplete}

Neither of these are in standard Crystal format for a formula or a field...so what are they???

if not a formula or field then there is probably your problem....



Jim Broadbent

 

[synapsevampire]

Jim: Those are running totals.

Are you stating that the following does not work?

if {#rTotal} <> 0 then totext(Round({#rTotalComplete}%{#rTotal}, 1),1) else &quot;N/A&quot;

-k

 

[cheerfulskeptic]

Thanks,
the second post fixed the problem.

 

[Ngolem]

SV- Sorry I rarely use RT's so missed it

No I didn't say it wouldn't work...just that I would do it differently

Jim Broadbent

 

[Reebo99]

In :

if {#rTotal} <> 0 then totext(Round({#rTotalComplete}%{#rTotal}, 1),1) else &quot;N/A&quot;

Wouldn't :

if {#rTotal} <> 0 then totext({#rTotalComplete}%{#rTotal}, 1) else &quot;N/A&quot;

Do the same thing? i.e. removing the round() function?

Reebo
Scotland (Sunny with a Smile)

 

[synapsevampire]

Jim: Sorry, the second part was meant for the poster, not you.

-k