topic Question about Sum expression - filtering by date in App Development

Question about Sum expression - filtering by date

jerryr125 — Sun, 28 Nov 2021 11:58:07 GMT

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

Re: Question about Sum expression - filtering by date

AshutoshBhumkar — Sun, 28 Nov 2021 17:58:33 GMT

Hello,

Try below expression

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

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

Re: Question about Sum expression - filtering by date

eliran — Sun, 28 Nov 2021 17:59:38 GMT

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