OR function for null

[smilingjohn]

Hi All, 

I have a really weired output from the set anaylysis, I need ti display those ID's which ibcludes null values from either one of the column . The below condition works fine when there is value in Case ID and or INcodent ID but this ives wrong total when there is values in the both the fields . it just adds them . 

It shows correct ID's but doubles the total when there is values in both the fields (CASE_ID and INCIDENT_ID)

How can I fix this ? 

Expression :

=
count({<Department{'HR','Sports'},Type={'Indoor'},CASE_ID-={'null'}>}ID)
+
count({<Department{'HR','Sports'},Type={'Indoor'},INCIDENT_ID-={'null'}>}ID)

Thanks

in Advance

[rubenmarin]

Hi @smilingjohn, try creating a numeric value for year month like Year(Date) & Num(Month(Date), '00') as CreatedMonthYearNum, using this field it should work.

Also doubles quotes may be used when using comparisons: Count({<Dep={'Sales'} CreatedMonthYearNum={">201711"}>}ID)

[smilingjohn]

Hi Ruben ,

Sorry By the time I changed my post U have replied to th previous one , which I have done the way u suggested . 

Thanks For it . 

Can you please look into the latest post of mine which I holding me 

[rubenmarin · Accepted solution]

Hi again, you can create the OR in set analysis as:

count(<Department{'HR','Sports'},Type={'Indoor'},CASE_ID-={'null'}>+<Department{'HR','Sports'},Type={'Indoor'},INCIDENT_ID-={'null'}>} JIRA_KEY_ID)

[rubenmarin]

Now that I see it... there are 2 different fields you want to count? can't it be summarized using only one field?

[smilingjohn]

@rubenmarin  Thanks a lot sir it worked 😀

And i renamed it as One field