Question about Sum expression - filtering by date

[jerryr125]

HI - I have the following expression in a table chart:

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}>} FABS(transactionquantity))

Works perfectly...

But when I add a filter to only include transaction dates on or after 06/10/2021 I receive an error.

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}, [transactiondate.autoCalendar.Date]>{'06/10/2021'}>}FABS(transactionquantity))

Any thoughts how I can accomplish the above ?

Thanks -

Jerry

[AshutoshBhumkar · Accepted solution]

Hello,

Try below expression 

Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'}, 

[transactiondate.autoCalendar.Date]={">=06/10/2021"}>}FABS(transactionquantity))

[eliran]

Hi,

This part is wrong -[transactiondate.autoCalendar.Date]>{'06/10/2021'}

You need to alter it as follows

[transactiondate.autoCalendar.Date]={'>06/10/2021'}

BR,

Eliran