Alteryx-Core Data Transformation Practice Question
Which tool configuration is most appropriate if you need to calculate a running total of sales while maintaining the original row structure?
⚠ Common exam trap
Candidates often attempt to use a standard Formula tool for running totals, failing to realize it cannot reference previous rows, which leads to errors or incorrect, static calculations.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Multi-Row Formula tool
The Multi-Row Formula tool is designed for calculations that depend on preceding or succeeding row values. By setting the 'Num Rows' to 1, you can access the previous result and add it to the current value, creating an efficient running total. This is a critical skill for temporal and sequence-based analysis where simple row-level calculations are insufficient for capturing dependencies.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Formula tool
Why it's wrong here
The Formula tool operates on a row-by-row basis and has no inherent memory of previous rows. Therefore, it cannot calculate a running total unless the data has been pre-processed to contain the necessary context, making it inadequate for this specific sequential calculation requirement.
- ✓
Multi-Row Formula tool
Why this is correct
This tool is specifically designed for calculations that require access to values from surrounding rows. It allows for creating a new field by referencing previous records using the [Row-1:Field] syntax, enabling the creation of running totals or other complex sequence-dependent metrics without changing the overall dataset structure.
- ✗
Summarize tool
Why it's wrong here
The Summarize tool performs aggregations that collapse rows based on group keys. It does not output a row for every input record in the context of a running total; instead, it outputs the final accumulated result, which fails to meet the requirement of maintaining the original row structure.
- ✗
Transpose tool
Why it's wrong here
The Transpose tool changes the structure from wide to long. It is used for reshaping data, not for performing mathematical calculations across rows. Attempting to use it for a running total would simply pivot the data, which is irrelevant to the requirement of calculating a cumulative sum.
About these practice questions
This Alteryx-Core question is part of Courseiva's 142-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Alteryx exam blueprint
This Alteryx-Core practice question is part of Courseiva's free Alteryx certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Alteryx-Core exam.