Skip to main content
Validation checks formula syntax and semantic references before a write. Verification checks whether the resulting values match the business rule.

​
Validate

Use dry_run: true with the write that would own the actual change:
  • Use edit_table_blocks for a visible saved table target.
  • Use edit_variables with action: "set_values" for a table-independent formula.
Validation checks:
  • Expression syntax
  • Condition syntax
  • Variable references
  • Function names and arguments
  • Semantic compatibility
Correct reported errors before applying the same intended change.

​
Read after writing

Inspect the write result:
  • Attempted count
  • Applied count
  • Rejected count
  • Per-item expression or condition errors
An atomic write applies all requested changes together or applies none. If a partial write reports rejected items, correct and retry only those unsuccessful items.

​
Verify calculated behavior

Use inspect_table_blocks on the relevant saved table after a material change. Check representative dates, segments, formula origins, and source information. Examples:
  • Compare Gross Profit with Revenue minus Cost of Goods Sold
  • Check a Department formula for two different departments
  • Check both sides of Last close for a formula-range change.
  • Compare the intended Scenario with the Scenario that was written.

​
Report clearly

State what was written and whether verification matched the request. Disclose any inferred table, Scenario, or business assumption that materially affects the result.