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.

Calculation based on field containing value & all related records

ShannonM
in Calculation Engine (Define Fields)

Featured Replies

Hi,

I am having a problem with a calculation involving an IF function.

I want the IF statement to be based on whether or not a field contains a specific value. However, I am having trouble differentiating between the field containing just that value vs. that value along with other values.

The field in question is based on a value list of countries.

The beginning of my IF statement is:

If(CountryName="Canada";" CA").

For most records the CountryName field contains many different countries, not just "Canada" alone. I want the calculation to work on any record that has "Canada" but not only "Canada".

So right now it is not applying the calculation to any records that have:

Canada

USA

Australia

In the Country Name field. That is, the calculation is only being applied to records that have "Canada" only in the Country Name field.

Is there a way to fix this in the syntax of my calculation?

Look up Case() in the help file.

No, look up Position(), PatternCount() and FilterValues().

Much more helpful.

Create an account or sign in to comment

https://fmforums.com/topic/53206-calculation-based-on-field-containing-value-all-related-records/
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.