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 

Answers

  • 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