Formula error - duplicate data occuring

[mckenseycatterton]

Hello,

I'm having issues with a formula populating in incorrect data. I'm combining 2 datasets into a formula via an append function. One dataset has 2 rows worth of data (P2 for infrastructure and third party) and the other 1 row worth of data (P3 infrastructure). What I want the formula to show is a blank under P3 % remediated for third party (since there is no data), instead of for some reason pulling in the P3 infrastructure data as a duplicate for third party. The current formula is skewing my timeliness %. 

[stvnhdmpa]

An Append will always add all the data from one data source to the other.  Can you join them or use a Find and Replace instead?

[stvnhdmpa]

Is this what you are trying to achieve?

[mckenseycatterton]

Yes, that is what I'm trying to achieve. I'll see if that works. 

[stvnhdmpa]

Hi @mckenseycatterton  - Just checking in to see if you the results you were looking for?  If so, can you mark it as solved?