Sum Select Help

AppSheet AppSheet Q&A
1

HI everyone,

I tried to sum the amount per today…

=Sum(SELECT(Totzag[amount],And( [_THISROW].[Order id] = [order id],Date(DATETIME)=TODAY())))

It won’t work, any ideas?

Thanks in advance

2

If DATETIME is one of your columns it needs to be in brackets

2 Likes