Jump to content

Change Excel Formula to Filemaker Calculation


This topic is 4331 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 4331 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.