Which GetDataCell expression would users use to calculate the total of two scenarios?

Which GetDataCell expression would users use to calculate the total of two scenarios?

• A. Ratio
• B. Variance
• C. Sum
• D. Custom

Answer: (C)

Summing two scenarios means adding their values to produce a single total. The GetDataCell Sum expression is designed to do exactly that: it returns the arithmetic addition of the operands, giving the combined total of the two scenarios. Using a ratio would compute one value relative to the other, not a total. Variance measures how much the values differ from each other or from their mean, not their sum. A Custom expression could implement a total, but Sum is the straightforward, built-in way to add two numbers without extra logic. For example, if scenario A is 120 and scenario B is 80, Sum yields 200, which is the total you’re looking for.

Summing two scenarios means adding their values to produce a single total. The GetDataCell Sum expression is designed to do exactly that: it returns the arithmetic addition of the operands, giving the combined total of the two scenarios.

Using a ratio would compute one value relative to the other, not a total. Variance measures how much the values differ from each other or from their mean, not their sum. A Custom expression could implement a total, but Sum is the straightforward, built-in way to add two numbers without extra logic.

For example, if scenario A is 120 and scenario B is 80, Sum yields 200, which is the total you’re looking for.