Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cmutombo
Contributor III
Contributor III

SUMIF Date >=

Hi People, 

Look this formula :  Give me : Sum of VOICE REVENUE of  01 Jan 2021 (Formula is working correctly)

=num(((Sum({$<[DATE_]={"$(=timestamp(MonthStart(date(today()-1))))"},SERVICE={'VOICE'}>}REVENUE))/1.26)/1000,'0.0')

But, I am Looking for good syntax to have : 

Sum of VOICE REVENUE of All Dates > = 01 Jan 2021 (From 01 Jan 2021 to 21 Jan 2021)

regards, 

2 Replies
PriyankaShivhare
Creator II
Creator II

create a flag for MTD in load script calendar

if (Month(Date_)=Month(today()) ,1) as MTD_Flag

=num(((Sum({$<MTD_Flag={1},SERVICE={'VOICE'}>}REVENUE))/1.26)/1000,'0.0')

Thanks,

Priyanka

 

cmutombo
Contributor III
Contributor III
Author

Hi Mrs

Thank you for your feedback. But I found the best way below : 

=num(((Sum({$<[DATE_]={">=$(=timestamp(MonthStart(date(today()-1))))"},SERVICE={'VOICE'}>}REVENUE))/1.26)/1000,'0.0')