Sumif based on month ?

Nicolas6901 · 2025-04-04T10:52:48+00:00

There was an error rendering this rich post.

A first module collects a quantity per month, client, and product. For each month/client/product, a warehouse (list element) is defined. Based on the warehouse, the start month is calculated (Time Period Format). My goal is to be able, in another module, to sum the quantities by products/warehouses/start month. When I try to create a formula like Quantity[Sum: Warehouse of departure, Sum: Product, Sum: Start Month of Departure], it does not apply.

Do you have any idea to help me achieve the expected result?

Accepted answers

All comments

sobaid

@Nicolas6901 , can you share the screenshot of error you are facing?, your formula seems fine, provided customer & product in mapped in source are list items and Month of departure is time period formatted.Also share the blueprints of your both modules

lokeshm

@Nicolas6901 you can create another line item named current month .find the difference and use POST to calculate the data.

And in the Another module , you need to create another line item, which has all 3 dimensions (Product,Customer and Ware house ) and in this line item bring the Post calculated value .⇒then refer this line item in the Expected module Qty using the select Function

Hope this helps

Dikshant

Source Module-Warehouse of departure needs to be list formatted line item (Warehouse list)

Product line item-Product list formatted- Formula: ITEM(Product list)

Month of departure line item: time period formatted

Target module has dimension as Product list, Warehouse list, Time formula as:

Source Module.Quantity[SUM: Source Module.Product, SUM: Source Module.Warehouse of departure, SUM: Source Module.Time]

Nicolas6901

Thank you, it works well !

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…