editing aggr expression

[Anonymous]

Hi Everyone

Can someone help me how can i modify below expression

with this condition: if HOURS is >6 but <12

Sum({<WEEK = {"$(=MaxString(WEEK))"}>}Aggr(If(Count({<WEEK = {"$(=MaxString(WEEK))"}>}DEVICE)=1,1,0) and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS)<=6, DEVICE))*-1

Thanks and hope to hear from you.....

[Anonymous]

Sum({<WEEK = {"$(=MaxString(WEEK))"}>}Aggr(If(Count({<WEEK = {"$(=MaxString(WEEK))"}>}DEVICE)=1,1,0) and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS)<=12 and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS)>6, DEVICE))*-1

[sunny_talwar · Accepted solution]

May be this

Sum({<WEEK = {"$(=MaxString(WEEK))"}>} Aggr(

If(Count({<WEEK = {"$(=MaxString(WEEK))"}>}DEVICE) = 1 and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS) > 6 and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS) < 12,1,0), DEVICE))*-1

[Anonymous]

Hi Sunny & Robin,

Both your formula works well..

thanks and have a good day!