Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Change Excel Formula to Filemaker Calculation

zdub
in Calculation Engine (Define Fields)

Featured Replies

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.

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.

Create an account or sign in to comment

https://fmforums.com/topic/77445-change-excel-formula-to-filemaker-calculation/
Go to topic listing

Important Information

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

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.