Change Excel Formula to Filemaker Calculation

[zdub]

Hi I'm new to filemaker and I don't know if this topic has been addressed here or not. If so could you just link me to the thread, thanks. My issue is as follows, I have Multiple rows of one order in Excel, each with repeating and or different info in each cell. I want to combine all order rows with the same order# into one record in filemaker. I figured out how to combine the data into one order, but because the product info is repeated everytime info changes I just want to show all unique info once.

I have an excel formula

=IF(AA2=AA1,"",AA2)

AA1= PROD_CODE

AA2= PROD_CODE

How do I make that into a calculation in Filemaker? Thanks for any help.

[comment]

The best way to do this in Filemaker is to produce a report summarized by PROD_CODE. Place the PROD_CODE field in the sub-summary part only.