Parameter in calculated fields in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sales amounts in column A and a discount rate parameter value in B2.

Cell	Value
A1	Sales
A2	100
A3	200
A4	300
B1	Discount Rate Parameter
B2	0.1

Formula Trace

Discounted Sales = SUM([Sales]) * [Discount Rate Parameter]

Step 1: SUM([Sales])

Step 2: [Discount Rate Parameter]

Step 3: 600 * 0.1

Cell Reference Map

Sales

↓

Discount Rate Parameter

The formula uses sales values from cells A2 to A4 and the discount rate parameter from B2.

Result

   A       B       C
1 Sales   Discount Rate Parameter  Discounted Sales
2 100     0.1                     60
3 200
4 300

The calculated discounted sales value 60 is shown in column C, computed by multiplying total sales by the discount rate parameter.

Sheet Trace Quiz - 3 Questions

What is the total sum of sales used in the calculation?

A 300

B 100

C 600

D 0.1

Key Result

Calculated field multiplies SUM of a measure by a parameter value.