Sum Select Help

[Itay_Golan]

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

[Heino_Matthee]

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