## Sum based on specific value from another column?

Certified Master Anaplanner

## Sum based on specific value from another column?

Hi All,

For line 3 in my module, I am trying to sum ONLY the lines where Total Inventory = Regular (Dimension), how should I setup this equation?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Sum based on specific value from another column?

If you don't already have a SYS module for the Inventory dimension, create one.  Create a line item (formatted as a boolean) and name it "Sum for Regular".  Click the boolean to true for all members that you want to be in this calculation (could be one, could be many).

In your module, the formula would be: If SYS Inventory.Sum for Regular then do the sum else 0.

Hope this helps,

Rob

2 REPLIES 2
Moderator

## Re: Sum based on specific value from another column?

If you don't already have a SYS module for the Inventory dimension, create one.  Create a line item (formatted as a boolean) and name it "Sum for Regular".  Click the boolean to true for all members that you want to be in this calculation (could be one, could be many).

In your module, the formula would be: If SYS Inventory.Sum for Regular then do the sum else 0.

Hope this helps,

Rob

Certified Master Anaplanner

## Re: Sum based on specific value from another column?

Thank you very much Rob! That helped!