問題文
A formula field multiplies a quantity field by a unit price field. On records where the unit price is empty the formula returns blank, and a report built on it shows empty cells. Which change fixes this without editing the formula expression?
選択肢
- Wrap the formula in the TEXT function, so that blanks become the string zero in the report cells.
- Change the formula field's blank field handling so that blank fields are treated as zeroes.
- Add a validation rule that requires the unit price on every record, then run a data load that fills the missing values with zero so that the formula never meets a blank, and blank handling cannot be configured on a formula field.
- Mark the unit price field as universally required, which makes the blank case impossible from then on.