OBI: Internal Vs. External Postings Report

Summary:

Outputting Interval Vs. External Postings for Open Requisitions

Content (required):

I have a report that gives me all Open Requisitions. We would like to add a column that tells us if the Requisition is posted Internally, Externally or both. If it is Open and unposted, those two columns would be Null. I created two columns that tell me this, but if a Requisition is posted Internally and Externally I get two rows for that Requisition. Below is the formula I'm using. I noticed that for unposted Requisitions, it still shows it as posted Internal and External. I'm assuming this is because it was once posted.