Apr 02 2021 09:23 AM
Hello,
Can anyone explain why the below formula yields 0 as a result please? (I want the sum of all quantities of the last year.)
Apr 02 2021 09:30 AM
SolutionPlease use "<="&[@date] instead of "<=[@date]", etc. Second one literally returns the text inside the quotes which definitely couldn't be found.
Apr 02 2021 10:08 AM - edited Apr 02 2021 10:26 AM
Thank you, that definitely clears up one problem. I adapted accordingly, but I must still be making some stupid mistake because the value still remains zero although the sum shouldn't be:
(edit: added the spreadsheet)
Apr 02 2021 10:30 AM
Apr 02 2021 10:35 AM
Yes, in general it's the best practice to define proper types returning the table to Excel sheet or to other source.
Apr 02 2021 09:30 AM
SolutionPlease use "<="&[@date] instead of "<=[@date]", etc. Second one literally returns the text inside the quotes which definitely couldn't be found.