Hello,
I'm trying to have a table return certain summed up values based on a date ranged, which is entered by a user in a seprate Klip.
Unfortunately, I have not been able to figure out how to accomplish this, and keep getting system errors. \
Below is my formula and a screenshot of my table as well.
My user input comes from a table of dates in the following format "MMMM-yy", and the dates listed in the table I'm working on are in the "d-MMMM-yy" format, which I've added a DATE_CONVERT thinking it would fix it. But it did nothing.
SELECT(SUM(Goal_Quantity,BETWEEN(GROUPBY(DATE_CONVERT(Goal_Date,"d-MMMM-yy","MMMM-yy"),Goal_Date),$dateRangeStart,$dateRangeEnd)))