Only calculate if numeric


This Discussion is public



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

Reply to this Discussion