Duplicates appearing - need true data

Erin Caby-47393

Summary

I have one field that is pulling different dates - need true data

Content

Hi Group,

I'm having an issue getting a single date to pull in correctly in OBI. The field is under Requisition Posting>Posting Date.

What I need is the date the req was posted - however, it pulls in 2 separate dates causing duplicates on my report. 9/19/16 was the actual date posted. The "different date" is shown below.

Any assistance is greatly appreciated!

First Fully Approved Date	Posting Date
08/03/2016	09/19/2016
08/03/2016	09/20/2016

Reena Trangri

Hi,

Have you tried to pull "Requisition Posting"."Posting Board Type" field too. Multiple rows could be fetched if there are different Board Types like "Internal"/"External"

If you wish to see the recent posting Date details, you can try using a Max on Posting Date column and it will avoid duplicates.Hope this helps.

Thanks and Regards,

Reena Trangri

Erin Caby-47393

Hi Reena,

Thanks for responding! I'm not sure how to add a max on Posting Date column. Would you be kind enough to explain a bit more for me?

Thank you!

Erin

 

Reena Trangri

Hi Erin,

  Edit the Formula for Posting Date column and enter the expression as Max("Requisition Posting"."Posting Date")

Thanks and Regards,

Reena