SUMIF Date >=

[cmutombo]

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, 

[PriyankaShivhare]

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]

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')