How to calculate based upon a range?

CommunityMember126793
Regular Contributor

How to calculate based upon a range?

Hi Team,

 

Can anyone please help here to make the Commission calculated based upon the range defined in 1 system module? 

CommunityMember126793_1-1625543910261.png

 

Second last column in 2nd module (besides commission) to be referred in above defined module.. and whichever range the % is falling.. that commission% must be referred in the below module..

 

Much appreciated in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: How to calculate based upon a range?

Hi @CommunityMember126793 

 

LipChean_Soh_0-1625547010708.png

1. 'Range' list is created with a top level item of 'All Range'.

 

LipChean_Soh_1-1625547065843.png

2. 'SYS Range Details' is created with summary turned off for line item = Low, High, Comm%

 

LipChean_Soh_3-1625547168852.png

LipChean_Soh_5-1625547205667.png

3. Depending on the original 'Applies To' of your module, you can add 'Range' to it.

 

Thanks,

LipChean

View solution in original post

1 REPLY 1
LipChean_Soh
Certified Master Anaplanner

Re: How to calculate based upon a range?

Hi @CommunityMember126793 

 

LipChean_Soh_0-1625547010708.png

1. 'Range' list is created with a top level item of 'All Range'.

 

LipChean_Soh_1-1625547065843.png

2. 'SYS Range Details' is created with summary turned off for line item = Low, High, Comm%

 

LipChean_Soh_3-1625547168852.png

LipChean_Soh_5-1625547205667.png

3. Depending on the original 'Applies To' of your module, you can add 'Range' to it.

 

Thanks,

LipChean

View solution in original post