Adding up 2 counts results in - while 1 has a value, how to show the value instead of - ?

[NLPTA]

The goal is to have an FTE demand calculation.
count 1: 
Tickets of type incident, multiplied with some variables + the median of ticket life. divide by 1*update time.(1 update every hour needed). divide by weeks(depending on date selection) divide by 60 to get hours, and divide by 8 on shift duration to get an FTE demand.

(COUNT({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'0'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24))))/1*vUpdate))
/vWeeks/60/8

Result : ( in a pivottable)

Count 2:
similar for problem tickets.

((COUNT({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve + vPrevalidation +
((MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24))))/24/2*vUpdate)))
/vWeeks/60/8

Result:

Now the problem is when I combine them:

(((COUNT({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve + vPrevalidation +
((MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24))))/24/2*vUpdate)))+

(COUNT({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'0'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24))))/1*vUpdate)))

/vWeeks/60/8

Result:

How do I get the value to show for Monday night as example, 0,97(incidents)+0(problems)=0,97
and not 0,97+0=0

[NLPTA]

updated Undressed version:

MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'1'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])))
+
MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'1'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])))

Also this version results in 0,97+ - = -
It has to do something with the median

[vinieme12 · Accepted solution]

use Coalesce() 

Coalesce(MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'1'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE]))),0)
+
Coalesce(MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'1'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE]))),0)

[NLPTA]

This worked perfectly! thank you very kindly sir.

[NLPTA]

Now i have 1 more request 😉 the full expression is pretty big. can this be reduced to a smaller version and combine some things smartly?

((COUNT({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve + vPrevalidation +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24/2*vUpdate)+
COUNT({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'2'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve + vPrevalidation +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'2'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24/5*vUpdate)+
COUNT({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'3'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve + vPrevalidation +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'3'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24/10*vUpdate)+
COUNT({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'4'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve + vPrevalidation +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'PROBLEM'},TICKET_INTERNALPRIORITY={'4'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24/10*vUpdate))+
(
COUNT({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'1'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'0'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/1*vUpdate)+
COUNT({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'2'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'2'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'0'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/1*vUpdate)+
COUNT({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'3'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'3'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'0'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24*vUpdate)+
COUNT({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'4'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'INCIDENT'},TICKET_INTERNALPRIORITY={'4'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'0'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24*vUpdate))+
(
COUNT({<TICKET_TICKETTYPE={'CHANGE'},TICKET_INTERNALPRIORITY={'1','2','3','4'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'CHANGE'},TICKET_INTERNALPRIORITY={'1','2','3','4'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24/14*vUpdate))+
(
COUNT({<TICKET_TICKETTYPE={'SERVICE REQUEST'},TICKET_INTERNALPRIORITY={'1','2','3','4'},TICKET_LINEFLAG={'1'}>}TICKET_TICKETID) *
(vIntake + vCreation + vDispatch + vResolve +
((Coalesce(MEDIAN({<TICKET_TICKETTYPE={'SERVICE REQUEST'},TICKET_INTERNALPRIORITY={'1','2','3','4'},TICKET_LINEFLAG={'1'},TICKET_STATUS={'Closed','Resolved'}>}
(([TICKET_RESOLVEDDATE]-[TICKET_REPORTDATE])*24)),0)))/24/7*vUpdate))+
(
COUNT({<TICKET_TICKETTYPE-={'WARRANTY','MONITOR'},TICKET_LINEFLAG={'1'},RelActTICKET_TYPE={'ACTIVITY'},RelActTICKET_STATUS ={'CLOSE'}, RelActTICKET_OWNERGROUP={'FS005'},RelActTICKET_VIONSITE={'Yes'}>}TICKET_TICKETID)*vUpdate_CO)+
(
COUNT({<TICKET_TICKETTYPE-={'WARRANTY','MONITOR'},TICKET_LINEFLAG={'1'},TICKET_VIMIM={'1'}>}TICKET_TICKETID) *
(vUpdate_Mi +
((Coalesce(Median({<TICKET_LINEFLAG = {1},TICKET_TICKETTYPE={'INCIDENT'},TICKET_STATUS={'Closed','Resolved'},TICKET_VIMIM={'1'}>}
(([MIM resolution time Minutes]-[MIM created time Minutes])/60)),0)))/0.25*vUpdate))
)
/vWeeks/60/8