70-779 · Question #49
You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula. ([Total Sales Current Year] - [Total Sales Last Year]) / [Total Sales Last…
The correct answer is A. an absolute value of 0. The SalesGrowth measure will give us a % value of e.g. +1.5% if there is a growth, or -2% if it's less. You can't compare the % value to absolute € numbers but 0 as a target will work fine, as it's only "not achieved" if there is no growth but loss, or growth values < 0.
Question
You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula. ([Total Sales Current Year] - [Total Sales Last Year]) / [Total Sales Last Year] Total Sales Current Year is a measure that calculates the sales from the current calendar year. Total Sales Last Year is a measure that calculates the sales from the previous calendar year. You need to create a KPI that displays a red icon when the sales growth is less than last year. What should you use to define the target value?
Options
- Aan absolute value of 0
- Bthe Total Sales Current Year measure
- Can absolute value of 100
- Dthe Total Sales Last Year measure
How the community answered
(23 responses)- A83% (19)
- B9% (2)
- C4% (1)
- D4% (1)
Explanation
The SalesGrowth measure will give us a % value of e.g. +1.5% if there is a growth, or -2% if it's less. You can't compare the % value to absolute € numbers but 0 as a target will work fine, as it's only "not achieved" if there is no growth but loss, or growth values < 0.
Topics
Community Discussion
No community discussion yet for this question.