How to put less than and greater than in my set analysis

[jamiemcc]

Hi Guys,

I want to add both less than -10 and greater than 0 to below.

The below works but i cant get the greater than 0 to work

=If(Aggr(Sum(Task_Time_Hours_Week_Google - Task_Time_Hours_Week_Users),[Personal Gmail], NewBmWeek) >=-10.00 , [Personal Gmail], Null())

Any ideas?

Jamie

[jbhappysocks]

Hello

You will have to create two conditions like

=If(
Aggr(Sum(Task_Time_Hours_Week_Google - Task_Time_Hours_Week_Users),[Personal Gmail], NewBmWeek) <=-10.00
or
Aggr(Sum(Task_Time_Hours_Week_Google - Task_Time_Hours_Week_Users),[Personal Gmail], NewBmWeek) >0.00
,

[Personal Gmail], Null())

Create a variable  vVar= Aggr(Sum(Task_Time_Hours_Week_Google - Task_Time_Hours_Week_Users),[Personal Gmail], NewBmWeek) to make it

If(  $(vVar) <=-10.00 or $(vVar) >0.00, [Personal Gmail], Null())