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

Field with ?

Featured Replies

I have a repport with a calculation field. When one of the referenced fields are empty the field is filled in with a "?". What can I do in order not to have this "?" in the field ?

I have already checked the check box that says do not evaluate if all referenced fields are empty, in the calculated field and the "?" is still there.

Can someone help me please.

LVA

Can you post your calculation? You will get more definitive help.

  • Author

Ok. The calculation - Case (Moeda = "Real"; Total Fatura / Moedas::Dollar ; Moeda = "Euro" ; (Total Fatura / Moedas::Dollar) *Moedas::Euro; Moeda = "Dolar"; Total Fatura)

Thanks, LVA

It could be trying to format a number that's too big for the field. Try formatting the field on the layout to show only 2 decimal places.

Or, it might be a division by zero problem (if Moedas::Dollar is empty or is zero.) You could add a case to your case statement for:

case(isempty(Moedas::Dollar) or Moedas::Dollar = 0; 0;

...

or something similar.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.