Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago
Solved

SUMX Formula creating a negative value

Hi,   The following formula produces a figure of -23 days which is incorrect, it should be 23 days.   Working Days = SUMX(FILTER(Deferrals,[regardingobjectid]= 'Cases'[incidentid]),Deferrals[Time...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    ArchStanton I'm thinking:

    Working Days = SUMX(FILTER(Deferrals,[regardingobjectid]= 'Cases'[incidentid]),'Cases'[Duration from Assigned (wd)] - Deferrals[Time in Deferral AP])

    or:

    Working Days = 'Cases'[Duration from Assigned (wd)] - SUMX(FILTER(Deferrals,[regardingobjectid]= 'Cases'[incidentid]),Deferrals[Time in Deferral AP])

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

ArchStanton I'm thinking:

Working Days = SUMX(FILTER(Deferrals,[regardingobjectid]= 'Cases'[incidentid]),'Cases'[Duration from Assigned (wd)] - Deferrals[Time in Deferral AP])

or:

Working Days = 'Cases'[Duration from Assigned (wd)] - SUMX(FILTER(Deferrals,[regardingobjectid]= 'Cases'[incidentid]),Deferrals[Time in Deferral AP])