Create range based on input line item

tompatrickting
Contributor

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.

 

tompatrickting_1-1617158116991.png

 

 

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

tompatrickting_0-1617157877037.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: Create range based on input line item

@tompatrickting 

 

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/6...

 

Rob

View solution in original post

1 REPLY 1
rob_marshall
Moderator

Re: Create range based on input line item

@tompatrickting 

 

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/6...

 

Rob

View solution in original post