Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I need to sum quantity based on input dates with below expression. Please, some one help let me know where I'm going wrong
=sum({<$(='[Shift Date]')={">=$(vStart)<=$(vEnd)"}>} Quantity)
The shift date is in the format, 2022-Sep-02.
I'm receiving 0 no matter the input I give on vStart and vEnd.
Where , vStart= 0 and vEnd = 0.
Try just using the field [Shift Date] instead of $(='[Shift Date])
I tried the below its still giving me 0.
=sum({<[Shift Date]={">=$(vStart)<=$(vEnd)"}>} Quantity)
What does it show in the expression editor at the bottom of the screen ? This should give you a clue to the issue.
It says expression okay. I think it is because of the shift date format. what do you say?
Is the Shift Date detected as a date in the data or a string ? What format are your variables showing ?
it is loaded in date format.