#VALUE! in the result

A value of the wrong type was used, most often an empty column or text in a calculation.

#VALUE! means that one part of the formula received a value it cannot work with. The most common causes:

• An empty text column in a calculation. {pulse.price} * {pulse.qty} gives #VALUE! when qty is an empty text column. Check for empty values first:

  IF({pulse.qty}="", 0, {pulse.price} * {pulse.qty})

• Text that is not a number, such as 12 pcs or N/A, in a calculation.

• A date General Caster can’t read in DATEVALUE, YEAR, MONTH or DAY. Dates from date columns always work. Typed dates work best as 2026-10-30.

The formula debugger shows which part of the formula produced #VALUE! and the value of every column it used.