# Report Builder Suppressing Zeros

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-11-30 09:03 UTC
**Views:** 371
**Replies:** 1
**URL:** https://www.epiusers.help/t/report-builder-suppressing-zeros/1641

---

## Post #1 by @system

<div id="ygrps-yiv-475177010">If you need that line to print but do not want anything to appear you have<br/>
to create a character variable for each numeric value &quot;IIF(Quantity &gt;<br/>
0,STRING(Quantity,&quot;-&gt;&gt;&gt;&gt;9.99&quot;),&quot; &quot;).<br/>
<br/>
Patrick J. Winter<br/>
Information Services Manager<br/>
sSc Specialty Screw Corporation<br/>
Vantage 4.00.901<br/>
<br/>
-----Original Message-----<br/>
From: Juliet Martin [mailto:<a rel="nofollow" target="_blank" href="mailto:jmartin@...">jmartin@...</a>]<br/>
Sent: Wednesday, November 29, 2000 02:58 PM<br/>
To: <a rel="nofollow" target="_blank" href="mailto:vantage@egroups.com">vantage@egroups.com</a><br/>
Subject: [Vantage] Report Builder Supressing Zeros<br/>
<br/>
<br/>
Is there any easy way to suppress zeros in a Report Builder Report on a<br/>
number that you have formatted with 2 decimals.  I am writing an Aged<br/>
Receivables Report and there are not always dollars in the 60 or 90 day<br/>
columns. So my report has a lot of .00 on it.  I know that there is<br/>
probably something really simple here that I am missing but I am willing<br/>
to bruise my ego a bit to get this done.  If I don&#39;t show decimals then<br/>
I wouldn&#39;t be having this problem but unfortunately I need the 2 decimal<br/>
places.<br/>
<br/>
Juliet Martin</div>

---

## Post #2 by @system

<div id="ygrps-yiv-35735548">NO, It did not work.  I thought it did.  I could have sworn the page had<br/>
blanks!  Then I tried it again and I got .00 just like you said.  I must<br/>
have tricked myself.  I am working on the conditional printing idea.<br/>
Just too excited I guess.  I also was testing two things at once; a dumb<br/>
thing to do anyway.  <br/>
<br/>
Sorry. :-(<br/>
<br/>
Juliet</div>

---


**Canonical:** https://www.epiusers.help/t/report-builder-suppressing-zeros/1641
**Original content:** https://www.epiusers.help/t/report-builder-suppressing-zeros/1641