Join Issue?

[cbaqir]

The sum(BASE_AU_AMT) for REQ_NAME = 'Deleted Request' is not coming through like the other REQ_NAME data.

For example, REQUEST_ID 169143 for USER_ID 46483 is showing as blank but should be coming through as 594.

The sum(BASE_AU_AMT) data for the other REQ_NAME comes through just fine. Any ideas?

Example attached.

Thanks,

Cassandra

[sunny_talwar · Accepted solution]

There is no REQUEST_ID = 169143 on the Fact Tab of the attached excel sheet

[cbaqir]

Duh.