My goal is to only apply the formula for Std Labor $ (N * L) to the cell in column AC if the value in AB is unique. I do not want to see $496.17 but once for each UniqueID. However, I do want to show $0 in the other cells with the same UniqueID. I cannot simply remove records in the UniqueID column with the Unique tool because I have other formulas that need to calculate. There could be something in column AF where a duplicate is in AC (see image below).
The formula that I am using in excel to perform what I am looking for in AC is: =IF(COUNTIF(AB$7:AB8,AB8)=1,N8*L8)
How can I do this in Alteryx? Is there any additional data that I might need to provide to be helpful in answering my question? Thank you so much in advance!!
Thank you so very much for such a quick response. It worked beautifully!