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

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

2 REPLIES 2
LipChean_Soh
Certified Master Anaplanner

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

CommunityMember126793
Regular Contributor

@LipChean_Soh  Hello

Struggling to pick the value against the same requirement but kind of different data set:

1. Below is system table where need to pick Name (list type property) but for testing purpose I have created TMG-Value (last column).. for easy pick (number data type) 

CommunityMember126793_0-1652363429938.png

blue print: list has top Level 

CommunityMember126793_2-1652363685782.png

 

2. below is the input module in which have pulled '2' from the list which to be checked in the system module (upper one) and pick TMG-Value... so here TMG column in below screen print should be 2 but coming as 0..

CommunityMember126793_1-1652363560469.png

blueprint: list has top Level 

CommunityMember126793_3-1652363841718.png

 

unable to track what's happening.