Best Practices for creating a formula dealing with SELECT

neg177
Regular Contributor

Best Practices for creating a formula dealing with SELECT

Hi, 

 

We are trying to create a formula that will subtract the sum of all the List Items, (excluding List Item 'Other'), from the overall Total of all the List Item totals added together. We were thinking of using the SELECT function to pull in the amounts for each List Items and then summing those all together in a SYS Module and then pulling in the result to our main Module. Please advise how this can be done with Anaplan best practices. 

 

neg177_0-1638395717935.png

We would want the Above Formula to be subtracted from a sum of all the other List Item Amounts. 

 

Thank you 

1 REPLY 1
Vinay VaradarajM
Certified Master Anaplanner

Hi @neg177 ,

 

Please see if you can use the below method:

 

1. Identify "Other" in a SYS Module

vinayvm_0-1638433717984.png

 

2. Using SYS in calculations

vinayvm_2-1638434023180.png

 

Best Regards,

vinayvm