Need Calc Help

sagarkpr

Hi Community,

I am working on this use case. Wondering if this is possible.

 

DAT01 Emp Details

Emp | Start Rate

EmpA  15

EmpB 16

EmpC 17

 

SYS02 Zone Module

Zone| Lower Range | Upper Range

ZoneA    14                 15

Zone B   15                 16

Zone C   17                 100

 

How can I identify which Zone does an employee falls in.

 

Final result needed

Emp | Zone

EmpA  Zone A

EmpB Zone B

EmpC Zone C

 

Any ideas?

 

MarkWarren

this micro lesson is just what you need
Working with Ranges, Tiers, or Bands - Anaplan Community

andrewtye

I was going to send @sagarkpr in the direction of one of @JaredDolich articles - but then he goes and says go there first!

JaredDolich

@sagarkpr 

@andrewtye is correct. I also made a video showing you how to build this.

https://www.youtube.com/watch?v=-DJ8Cxb18UE

 

sagarkpr

Thanks @MarkWarren I was able to adapt the micro lesson to my solution.

 

Just a followup question, I see another approach explained here

 

https://community.anaplan.com/t5/How-To/Planning-Sales-or-Invoices-Using-Tier-Pricing/ta-p/60614

Its conceptually the same thing but the difference is the System module that is used to figure our Tier or Band

 

In micro-lesson, it talks about create a module between the Dimension and Bands but this article talks about creating another list that could be list of all possible value a tier can have and then use that to calculate.

I see the tradeoff but is there a preference which one is better vs the other.

MarkWarren

Well done! Good question. There's no preference, it's just whatever works for you.
The lesson is a pretty simple example and if it fits your needs and is working then keep it.
@JaredDolich has shown a much more impressive way of doing it that can scale better, and he has a video! Very impressive. Check it out and see what works best for you.