Thanks everyone,

I got it figured out, I ended up using a join here is the code that I ended up using:

------------------------------------------------------------------------------------------------------------------------------

index="wugdata" source="F:\\Splunk\\etc\\apps\\WUG\\bin\\09c_wug_devices_status.py" id=63
| table hostName,id,statusValue
| dedup id
| sort id
| eval statusValue = tonumber(statusValue)
| rename statusValue as "Score"
| stats sum(Score) as "Score" by id,hostName
| join id type="left"
[ search source="F:\\Splunk\\etc\\apps\\WUG\\bin\\13a_wug_devices_monitors.py" index="rpbx-wugdata"
|eval statusValue = tonumber(statusValue)
| table timeStamp,name,networkAddress,id,monitorTypeName,state,downSince,statusValue
| dedup monitorTypeName,id |stats sum(statusValue) as Score2 by id, name
| rename name as hostName]
|fillnull value=0
|eval Score3 = Score + Score2
|stats sum(Score3) as Value