Skip to content
Advertisement

Apply different Adjustment Factor for different date range

I have a Table with SalesPerson and Sales for different dates. I have another table where I have SalesPerson and multiple date ranges where different Adjustment factor needs to be applied.

I can do this with a case statement when there is one or no row for the person in the adjustment factor table. But I am not sure how to loop through different date ranges for same salesperson

data and expected result

Advertisement

Answer

Do you just want a join?

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement