Create range based on input line item
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.
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