The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk

Only calculate if numeric

Labels

This Discussion is public

Notifications

Hi,

I have a field that requires some customization. We wanted to have an option of "N/A" being displayed

So Field-to-be-calculated is typically numeric, but there are situations we would like to just put "N/A" . Calculated-field refers to Field-to-be-calculated and currently it's showing "0.00" when Field-to-be-calculated = "N/A"

has anyone been through this, appreciate any help or workaround

Are you able to add a hidden field with the default value of N/A that has a conditional filter to determine if the value of the numeric field is equal to or less than 0?

Thanks Bobby,

It got me thinking , so i have added another field to refer to it.

Best regards, appreciate your advice

Discussion closed.