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
If DATETIME is one of your columns it needs to be in [ ] brackets
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
17 |