Create range based on input line item

tompatrick.ting

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

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