It’s very, very simple. ALL I’m trying to do is group a list of product writeoffs by Fridays so I can aggregate the total cost of each week.
Absolutely none of the “help articles” are fixing this problem.
Here’s what I’m not trying to do:
Filter out Fridays. I don’t need this because I’m trying to find the week’s total, not just the total of all writeoffs done on Fridays alone.
Group with the “EOWEEK” expression. This puts the writeoffs grouped by Saturday and I don’t want that. I’ve succesfully grouped them like this, however, so I KNOW that grouping them simply by a week day HAS to be possible.
Find the weekday numbers. I’ve already created a virtual column that does this, and I can then group the writeoffs by this virtual column, but it just groups them by all the Monday writeoffs, then all the Tuesday writeoffs, etc.
Make a yes/no virtual column. I’ve already tried this, and again it filters out everything that’s not a friday and only shows the writeoffs done on those specific days.
I need to tell appsheet to identify, not filter, the writeoffs that were done on Fridays, and then have them grouped like this:
And so on. I cannot for the LIFE of me get the expression right for this, and I’m 100% out of ideas. Frustrated to no end.