I am trying to label a field using two fields. Example: "[FieldOne] / [FieldTwo]". But I don't want to show FieldOne if the value is zero. Example: 0 / 1050 should read just 1050 whereas 1/1050 should read as 1/1050.
How do I leave out the zero values from the label?
I have tried a SQL query on the label - example: "Portion <> 0" but that just leaves out the label entirely, not just just the zero from field one.