Sum Select Help

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

2 Likes