Forum Discussion

BrianPierron's avatar
BrianPierron
Qrew Trainee
7 years ago

I need a formula that references an empty field to not display as zero.

I need a formula that references an empty field to not display as zero. Here is a bigger picture of what I've got going on to hopefully clarify what i'm looking for. I have parts checkout table th...
Formulas and functions
BrianPierron's avatar
BrianPierron
Qrew Trainee
7 years ago
Thanks for you help. i received a formula error saying that it was looking for "text" for the second "Related Item" part of the formula. Next i tried to convert the related item item fields to text and replaced the {related item} field with my converted to text fields but then the error was that it was looking for a number. Finally i combined the fields and it worked .

List(" ", 
IF([Related Item3]>0, [Rel3 Item to text]),
IF([Related Item4]>0, [Rel4 Item to text]),
IF([Related Item5]>0, [Rel5 Item to text]),

IF([Related Item6]>0, [Rel6 Item to text]),

IF([Related Item7]>0, [Rel7 Item to text]),

IF([Related Item8]>0, [Rel8 Item to text]))

I appreciate getting my on the right path
AustinK's avatar
AustinK
Qrew Commander
7 years ago
For the future you can do something like this instead which should save you some work.

IF([Related Item 1]>0, ToText([Related Item 1]))

There are many more like ToText that you can use to change a field in a formula.