Formula error - duplicate data occuring

Question

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 · Answer

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

mckenseycatterton · Answer

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

stvnhdmpa · Answer

Is this what you are trying to achieve?