SUMIF

[cmutombo]

Hi Community, 

I come to you with this formula  : 

=Sum({$<[DATE_]= {"$(=Date(Today()-1))"},SERVICE={'VOICE'}>}REVENUE)

Sumifs:

1. DATE_ = Yesterday

2. SERVICE = "VOICE"

I don't have a good result. Is the syntax good ?

Thanks in advance.

[edwin]

try it with single quotes:

=Sum({$<[DATE_]= {'$(=Date(Today()-1))'},SERVICE={'VOICE'}>}REVENUE)

[edwin]

also make sure DATE_ field is the correct/default date format