Can anyone tell me why there are two "Opportunity ID" fields in Answers for all opportunity-related subject areas (including Opportunity Product Revenue subject-areas)?
For example, in the "Opportunity Product Revenues reporting subject-area", has one with a column-formula of "*Opportunity."Opportunity ID"*" but the other appears as "*Opportunity.TEXT_31*". This is not a custom-field that we've created.
Given that you can add the same field to a report as many times as you want to, I can't understand the purpose or benefit of this field's existence.