Blank, zero and “not detected” are different nutrition entries

Your shelf

A missing field is a boundary, not an invitation to create a number.

In this guide

A blank means the source has not supplied a usable value in that field. Zero is a supplied numerical value, subject to its source’s measurement and labeling conventions. “Not detected” describes an analytical result and may depend on the method’s detection limit. These labels should not be silently treated as the same thing.

A sum with one missing ingredient

Imagine a bowl with 600 mg documented sodium from its known ingredients, plus a sauce whose sodium is unavailable. The complete bowl is not known to have 600 mg. You have a documented subtotal and an unknown addition. Naming it “at least the known subtotal” can communicate the boundary, but a strict maximum filter cannot certify the final order from it.

A genuine zero has a different role

If the sauce source supplies 0 mg, the numerical calculation can use that published figure while retaining the source convention. Do not claim laboratory absence merely because a rounded label displays zero. Equally, do not discard every zero as missing.

Preserve the status in your notes

Use a number plus a source status where needed. A spreadsheet that automatically fills blanks with zero may create attractive totals while corrupting their meaning. USDA’s documentation describes analytical data and unavailable nutrients; the FDA label guide explains the context of displayed nutrition amounts.

For GetMacros, an unknown should stay unknown in a meal, comparison and filter. If an important limit depends on that unknown, choose a fully documented order or consult the official source. The invented bowl example illustrates data handling, not a claim about any sauce or restaurant.

Sources and example boundaries

All food figures and prices in the worked example are invented to explain the method. They are not restaurant nutrition, tested recipes, shopping prices or personal dietary advice. Use the current label for the product you actually have.