Ignore nulls from total

[RutiTaumanRubin]

Hi Everyone,

I have create the following measure: 

(
Sum(If(Aggr(Avg(Aggr(
count({<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count({<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24')))>0.75,1,0))
/
count(Aggr(Avg(Aggr(
count( {<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count( {<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24'))))

)
/
Sum(total aggr(

Sum( If(Aggr(Avg(Aggr(
count( {<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count( {<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24')))>0.75,1,0))
/
count( Aggr(Avg(Aggr(
count( {<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count( {<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24'))))
,$(=GetObjectField(0,'CH24')))
)

I want the total to ignore nulls , I have tried to change tha calculatio to the following but it didn't work:

(
Sum(If(Aggr(Avg(Aggr(
count({<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count({<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24')))>0.75,1,0))
/
count(Aggr(Avg(Aggr(
count( {<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count( {<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24'))))

)
/
Sum(total {<$(=GetObjectField(0,'CH24')) = {'*'}>} aggr(

Sum( If(Aggr(Avg(Aggr(
count( {<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count( {<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24')))>0.75,1,0))
/
count( Aggr(Avg(Aggr(
count( {<ACTION_TYPE={"CLICKED"}>*<ACTION_TYPE={"DELIVERED"}>} DISTINCT ISSUE_ID)
/
count( {<ACTION_TYPE={"DELIVERED"}>} Distinct ISSUE_ID)
,EMP_KEY)),EMP_KEY,$(=GetObjectField(0,'CH24'))))
,$(=GetObjectField(0,'CH24')))
)

Could you please advise?

Thanks?