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?

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!

Accepted answers

LipChean_Soh

Hi @CommunityMember126793

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

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

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

Thanks,

LipChean

All comments

LipChean_Soh

Hi @CommunityMember126793

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

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

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

Thanks,

LipChean

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)

blue print: list has top Level

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

blueprint: list has top Level

unable to track what's happening.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…