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.
Juggernaut

help with calculation

Gaz 007
in Calculation Engine (Define Fields)

Featured Replies

I have a claculation

If ( (accomtype = "Residence") and (IsEmpty ( Res Alloc::Apt Num ) = 1) ; "No" ; "Yes")

what I want to do is if the accomtype field is set to residence and the field Apt Num in the Res alloc table is empty then it should equal no otherwise yes at the moment it always says yes.

HI Gaz

try this

Case(accomtype = "Residence" and IsEmpty (Res Alloc::Apt Num);"No";"Yes")

Phil

ps look up the case() function in your help files for a broader explanation.

  • Author

how would this work if i had 2 things to check

Case(accomtype = "Residence" and IsEmpty (Res Alloc::Apt Num); Case(accomtype = Hotel" and IsEmpty (Hotel Alloc::Rm Num);"No";"Yes")

is this correct, i want to be no if accomtype is residence and the apt num is blank or if the accomtype is hotel and rm number is blank otherwise it should be yes.

Case( accomtype = "Residence" and IsEmpty ( Res Alloc::Apt Num ) ; "No" ; accomtype = "Hotel" and IsEmpty ( Hotel Alloc::Rm Num ); "No" ; "Yes" )

So your case statement is formatted like this:

Case ( test1 ; result1 ; test2 ; result2 ; default result )

Create an account or sign in to comment

https://fmforums.com/topic/44803-help-with-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.