Configuration Challenge #R3
Goal
The goal of this configuration challenge is to get your familiar with various formulas. For this challenge, you will analyze formulas and try to determine why they were added. Comments were removed to make the task more difficult.
Difficulty
Medium.
Quota Formula
Questions
- What is the business intent?
- Why is there "[Reward].[end_date] <= $end"?
- What does the final IIF() statement do?
Related Articles
Configuration Challenge #R2
Goal The goal of this configuration challenge is to get your familiar with various formulas. For this challenge, you will analyze formulas and try to determine why they were added. Comments were removed to make the task more difficult. Difficulty ...Configuration Challenge #R1
Goal The goal of this configuration challenge is to get your familiar with various formulas. For this challenge, you will analyze formulas and try to determine why they were added. Comments were removed to make the task more difficult. Difficulty ...Answers - Configuration Challenge #R2
Challenge Here is a link to the original challenge. Answers The GetDate() function gets the day component of the calculation's start date (ex: the day component of 2021-10-15 is 15). The business purpose is to use a lower quota of 8000 when the ...Answers - Configuration Challenge #R1
Challenge Here is a link to the original challenge. Answers First code block The business purpose is to exclude transactions whose policy ID is strictly more than 8797. This logic could also be moved to a transaction saved query as an alternative ...Answers - Configuration Challenge #R3
Challenge Here is a link to the original challenge. Answers The business purpose is to calculate a recoverable draw repayment amount. A recoverable draw consists of advances which need to be repaid. A recoverable reward with a positive value is an ...