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.

'DEM CASE FUNCTIONS

markhardee
in Calculation Engine (Define Fields)

Featured Replies

This probably SOOOOO easy.. but..

I have the need to have the database make a few decisions. So, I figure CASE is the way.

However, I can get it work when there are two tests, results in the Calc but no more.

In particular...

Case(Shipped VIA="PYRAMID", MATCH SHIP CODE::Courier Charge, Shipped VIA="RUSH 4 U", MATCH SHIP CODE::Courier Charge, Shipped VIA="FEDEX", MATCH SHIP CODE::Courier Charge,"0")

Shipped Via is a pull down value list

MATCH SHIP CODE relates to Customers database

the default result occurs when the user enters Pickup (or anything other than PYRAMID or RUSH 4 U) in the Shipped VIA field. The last test for FEDEX is always ignored...

Is there a limit to the number of tests and result pairs that CASE can handle?

Thanks a diaperload in advance....

null

  • Author

BEFORE anyone hurts their head working on this... (red-faced) you must actually *HAVE* some data in the field for it to return a result!

I was testing with a record that had no value in the fedex field..

wimpering away.....

Create an account or sign in to comment

https://fmforums.com/topic/2994-dem-case-functions/
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.