Create range based on input line item

Hi ,

Please help/advise on how I can create a condition where we can automatically calculate our rebate based on the uploaded volume.

I created a separate list where i define the range and the corresponding rebate.

In my calculation module, i need to lookup the rebate based on the volume that was uploaded.

My problem is that the calculation module has no identifier to use as finditem to lookup in our system module.

Thanks in advance for helping.

Regards,

Tom

Accepted answers

rob_marshall

@tompatrick.ting

In order to get this to work, you will need to create a module which is dimensionalized by both the Rebate Range and the "source" module (the numbered list with Material in the second column).

Please check out this video: https://community.anaplan.com/t5/On-Demand-Courses/Working-with-Ranges-Tiers-or-Bands/ta-p/63734

As well as this article from @JaredDolich https://community.anaplan.com/t5/Best-Practices/Planning-Sales-or-Invoices-Using-Tier-Pricing/ta-p/60614

Rob

All comments

rob_marshall

@tompatrick.ting

In order to get this to work, you will need to create a module which is dimensionalized by both the Rebate Range and the "source" module (the numbered list with Material in the second column).

Please check out this video: https://community.anaplan.com/t5/On-Demand-Courses/Working-with-Ranges-Tiers-or-Bands/ta-p/63734

As well as this article from @JaredDolich https://community.anaplan.com/t5/Best-Practices/Planning-Sales-or-Invoices-Using-Tier-Pricing/ta-p/60614

Rob

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385