Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Try below expression
Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'},
[transactiondate.autoCalendar.Date]={">=06/10/2021"}>}FABS(transactionquantity))
Hello,
Try below expression
Sum({$<[materialid]={'mat01'}, [areaid]={'A15'}, [matnumber]={'90125'},
[transactiondate.autoCalendar.Date]={">=06/10/2021"}>}FABS(transactionquantity))
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