Date range using variables in if statement

[surface3]

Hi

I am trying to use if statements to sum two different fields. My current expression is as below:-

=if((Var_Metric_View=1) and (Month3='>$(vMonth_Current)<=$(vEndDateFY19))',

sum(Headcount),

if((Var_Metric_View=2) and (Month3='>$(vMonth_Current)<=$(vEndDateFY19))',

Sum([Total FTE])))

What I want to achieve is if Var_Metric_View is 1 and the date field 'Month3' is between two dates, which are stored as variables, then sum headcount

OR

if Var_Metric_View is 2 and the date field is between the same two dates then sum FTE.

Any help A.S.A.P. would be much appreciated.

[pradosh_thakur]

=if($(Var_Metric_View )= 1  and Month3 >  $(vMonth_Current) and Month3 <=$(vEndDateFY19) ,

sum(Headcount),


if( $(Var_Metric_View)=2  and Month3 > $(vMonth_Current) and  Month3  <=$(vEndDateFY19),

Sum([Total FTE])
))

[surface3 · Accepted solution]

Much appreciated.

Thank you!

[pradosh_thakur · Accepted solution]

@surface3  if your query is answered please close the thread else let us know.