How to calculate based upon a range?

CommunityMember126793
CommunityMember126793
in Modeling

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!

Tagged:

Best Answer

  • LipChean_Soh
    LipChean_Soh
    Answer ✓

    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

Answers

  • CommunityMember126793
    CommunityMember126793

    @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.

Categories