How do I include a date range in an Sum 'IF' statement?

[louise_atherton]

I'm hoping someone can help me. 

I have an expression which I need to include a date range but I'm struggling to include. 

Current expression

Sum(If(Isnull(Actual Value])=-1,(Estimated Value])))

I need to include a date range within the above

[Date created]={">=27/11/2022<=31/12/2022"}

Any help would be gratefully appreciated as I'm completely stumped. 

Many thanks

Louise 

[QFabian · Accepted solution]

Hi @louise_atherton , please check these options :

//Option if :
Sum(If(Isnull([Actual Value]) and [Date created] >= '27/11/2022' and [Date created] <= '31/12/2022', [Estimated Value]))

//Option Set Analysis

Sum({<[Actual Value] = E({"*"}), [Date created] = {">=27/11/2022<=31/12/2022"} >} [Estimated Value])

[louise_atherton]

Thank you so much for taking the time to respond.  

That worked an absolute treat and has fixed something I have been trying to resolve for some time. 

Many thanks

Louise 

[QFabian]

congratulations @louise_atherton , glad to help