Numeric blocks let you control how values are displayed: as a plain number, a currency amount, or a percentage, with optional rounding. This article explains the format options and one important gotcha about how percentages are stored.
The format controls appear in the Value (or Options) group of Input Field, Slider, Toggle, Selection, and Dropdown, and in the Display group of most result blocks.
Display as
Display as offers three choices: Number, Currency, %.
- Number — a plain number with thousands separators, for example
1,250. - Currency — a localized currency amount, for example
$1,250. - % — a number followed by a percent sign, for example
50%.
On the option blocks (Dropdown, Selection) and the Toggle, the Display as row appears only while Show numeric value is on — the format has nothing to format otherwise.
Currency selection
When you choose Currency, a currency picker appears beneath the control. Pick from the list of common ISO currency codes (USD, EUR, GBP, JPY, and many more). The display uses the currency's localized symbol, so a value formatted as EUR shows with € and JPY with ¥.
Decimal places
Result blocks show a Decimal places control: 0, 1, or 2, with More revealing No rounding, 3, and 4. With Currency, Numio keeps this at 0 or 2 (whole units or cents).
Rounding only changes the displayed value, not the underlying number used in formulas.
Percentages are stored as decimals
This is the key thing to know about the % format: a percentage is stored in the spreadsheet as its decimal equivalent. A field showing 50% substitutes 0.5 into the formula engine, and 100% substitutes 1.
That means:
- When you type a default value of
50into a percentage field, Numio saves it as0.5. - When you write formulas against a percentage input cell, use the decimal form (multiply by the base, don't divide by 100 yourself).
Sliders behave the same way: a percentage slider's min, max, and live value are converted between the percent display (0–100) and the decimal value (0–1) automatically.