How to sum number from different dates

[eddykwan_]

Hi everyone,

I need help for write logic expression or script for my expectation result.

This is my expect :

I want SUM InventoryQty based on Create date and Posting date.

example: on PostingDate 12/05/2021, I only can calculate InventoryQty based on CreateDate 12/05/2021 - 20/05/2021.

***********************************************************************************************

08/05/2021 - 09/05/2021 not include because of that date lower from PostingDate (12/05/2021)

and 21/05/2021 not include because of that date is the new value from PostingDate and that date will be calculate again.

Please help me to solve this problem and how to write this expression?

Thank you

[Mark_Little]

Hi there,

I would look at address this is in the script some how. it is hard to advised not know the date model. Are the they on the same table?

I would be looking to join the correct Posting Date to the transactions with right Created Date. 

[eddykwan_]

Hi Mark,

Yes its on the same table