How to delete List with Zero Across all Years and Not a Single Year

innocent.dike
innocent.dike
edited February 19 in Modeling

Hi Anaplaners,

I have a data upload using list properties. I would like to delete the List for Store with zero values in a calculation module Dimensioned by Store List.

The problem am facing is when I capture the sum of value with zero and I delete the Store List in the system module using "Delete using List selection" it deletes the store list with zero but ignore the same store with value for a different year.

Please how can you delete a store list with zero across the whole year and not just a particular year. The Year range from 2018 - 2025.

Your help will be appreciated.

Thank you.

Best Answer

  • devrathahuja
    devrathahuja
    Answer ✓

    Hi @Inno OStricth ,
    You can pull the value in another module with the dimension store list, by using SUM: store line item. This new line item would sum the value for ALL years as you would not be summing it by any other dimension but only store.

    You can then use this to delete the stores.

    Hope this helps! :)

Answers

Categories