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 |
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 |
Discounted Sales = SUM([Sales]) * [Discount Rate Parameter]A B C 1 Sales Discount Rate Parameter Discounted Sales 2 100 0.1 60 3 200 4 300
parameter in a Tableau calculated field?Sales Target inside a calculated field in Tableau?Discount Rate set to 0.1 (10%), what will be the result of this calculated field if Sales = 1000?Sales * (1 - [Discount Rate])Top N to filter the top N products by sales using this calculated field:RANK(SUM([Sales])) <= [Top N]Top N should be an integer.Top N is not integer, the comparison with rank (which returns integer) fails, causing filter issues.Top N is not set to an integer type -> Option AMin Sales. You want to show only products with sales greater than this threshold. Which calculated field formula correctly uses the parameter to filter products?Pass the test and this pattern moves unknown