how to sum nulls

[Tarig]

Hello guys

I am new to qlik, can someone help me to find what is wrong in my expression:

I am trying to sum earnings for certain Categories plus null values. thanks for helping 

=IF(
ISNULL (ContractCategoryGroup), Sum(${<ISNULL (ContractCategoryGroup)>} Round ((Earnings), -5)/1000000),
IF(
ContractCategoryGroup = {'Features', 'Dramatic', 'Commercials'}, Sum({$<ContractCategoryGroup = {'Features', 'Dramatic', 'Commercials'}>} Round ((Earnings), -5)/1000000)
)
)

[sunny_talwar]

The best way would be to create a new flag in the script like this

If(Len(Trim(ContractCategoryGroup)) = 0 or Match(ContractCategoryGroup, 'Features', 'Dramatic', 'Commercials'), 1, 0) as ContractCategoryGroupFlag

and then this

Sum({$<ContractCategoryGroupFlag = {1}>} Round(Earnings, -5)/1000000)

[Tarig]

I am so sorry but where I should create flag?

If(Len(Trim(ContractCategoryGroup)) = 0 or Match(ContractCategoryGroup, 'Features', 'Dramatic', 'Commercials'), 1, 0) as ContractCategoryGroupFlag

[sunny_talwar]

In the script

[Tarig]

are you saying under measures field

[sunny_talwar]

No my friend, in place where you modify script (back end)

[Tarig]

thank you for helping me. I don't have script because under data I have sql query