I am using a number property in a calculation. But the calculation won’t work if the number property is empty. is there any way to set 0 for empty in the number property?
Hi @SMomo,
What exactly should the calculation return if the number property is empty? Can you share a screenshot of your calculation?
Generally, you can use “is known” to check if the property has a value or not and/or an if statement to decide what should be returned when it isn’t. Create calculation and rollup properties
Best regards
@SMomo in that case, please see my previous reply, you can use an if statement and is_known to check whether the value is known, and if not, return 0:
if(is_known(property),property,0)
would translate to: return the value if it is known, return 0 if it isn’t.