Reg: Finding ID Format

[nitendra_tyagi]

Hi Team, 

I am trying to pull Finding data in the Power BI Report that shows the Finding ID in the table as 123 but not as FND-123. How is this solved in Archer to show the combination of FND dash Numbers (e.g., FND-760) , and is there a table we might find this combination as such? 

Same thing facing in (Quality Improvement Plan) QIP ID also, like we are getting 123, but not as QIP-123?  is there any table we might find this combination as such? 

Please suggest some solution.

Thanks 

[DavidPetty · Accepted solution]

@nitendra_tyagi it's not in a table per-say but part of the field configuration for those applications.  There configured to have a prefix in front of the ID so Archer automatically does that when it displays data for a record.  I don't know if that something you can do in Power BI, creating a custom field with a combination of text and data.