When viewing quick table calculations, such as Percent Difference from, that use a value in the previous column, what will be the first data value in the visualization?

Question

Options

• AZero (0)
• BNull
• CDuplicated from the nearest column
• DThe current value

• A
  89% (16)
• B
  6% (1)
• D
  6% (1)

Explanation

Option A is correct because a "Percent Difference from Previous" calculation computes (current − previous) / previous, and when there is no prior column to reference, the result defaults to zero (0) - representing a 0% difference from a nonexistent baseline.

Why the distractors are wrong:

• B (Null) is a common trap: null would mean "missing/unknown," but the tool treats the absence of a prior value as a defined starting point of zero change, not an undefined one.
• C (Duplicated from nearest column) applies to certain gap-filling or padding behaviors, not to percent-difference table calculations.
• D (The current value) would describe a running total or a "first value" reference calculation, not a percent difference.

Memory tip: Think of the first row as standing on the starting line - it hasn't moved from anywhere yet, so the difference is zero, not unknown (null).

No community discussion yet for this question.