3 Replies Latest reply: Nov 17, 2015 1:37 AM by kushal chawda

# Count If

Hello, I am trying to complete this calculation only counting data where the Location Column reads 'Remote'. Any ideas?

Sum(if(Type='T',[Time (Min)])/60/24)+Sum(if(Type='NT',[Time (Min)])/60/24))

/

((((
Count(Distinct Date&Name))*480)/60/24)-Sum(if(Type='P',[Time (Min)])/60/24)-(((Count(Distinct Date&Name)-Sum(if(Type='P',Quantity)))*30)/60/24))

• ###### Re: Count If

May be this:

Sum({<Location = {'Remote'}>} if(Type='T',[Time (Min)])/60/24) + Sum({<Location = {'Remote'}>} if(Type='NT',[Time (Min)])/60/24))

/

((((Count({<Location = {'Remote'}>} Distinct Date&Name))*480)/60/24)-Sum({<Location = {'Remote'}>} if(Type='P',[Time (Min)])/60/24)-(((Count({<Location = {'Remote'}>} Distinct Date&Name)-Sum({<Location = {'Remote'}>} if(Type='P',Quantity
)))*30)/60/24))

• ###### Re: Count If

Hi,

try every expression in set analysis.

Sum({<Location = {'Remote'},Type={'T','NT'}>}[Time (Min)])/60/24

/

(
(
(
(
Count({<Location = {'Remote'}>} Distinct Date&Name)
)*480
)/60/24
)
-
Sum({<Location = {'Remote'},Type={'P'}>}[Time (Min)])/60/24
-
(
(
(
Count({<Location = {'Remote'}>} Distinct Date&Name)
-
Sum({<Location = {'Remote'},Type={'P'}>} Quantity)
)*30
)/60/24
)
)

Regards

• ###### Re: Count If

=((Sum({<Type{'T'}>}[Time (Min)])/60/24)+(Sum({<Type{'NT'}>}[Time (Min)])/60/24))

/

(((Count(Distinct Date&Name)*480)/60/24)-(Sum({<Type={'P'}>}[Time (Min)])/60/24)-(((Count(Distinct Date&Name)-Sum({<Type={'P'}>}Quantity))*30)/60/24))