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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Try this

List(" ", 
IF([Related Item 1]>0, [Related Item 1]),
IF([Related Item 2]>0, [Related Item 2]),
IF([Related Item 3]>0, [Related Item 3]))