Sumif based on month ?

Nicolas6901

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?

sobaid

Hi

@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 !