I have the expression in my If Condition:
@lessorequals(int(item().virtualWorkPercentage), 0)
Without notice, I found out that the 0 can also be a NULL; how can I handle both?
Thanks!
Mike Kiser
I have the expression in my If Condition:
@lessorequals(int(item().virtualWorkPercentage), 0)
Without notice, I found out that the 0 can also be a NULL; how can I handle both?
Thanks!
Mike Kiser
Hi @ewinkiser,
We still have not heard back from you. Just wanted to check if the below suggestion from Nandan was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.
And, if you have any further query do let us know.
Hey,
You can use the below expression
equals(coalesce(item(). Virtualworkpercantage, ' '), ' ') to check whether the value is null and based on your requirement do the needful in your if condition. Is your ask to make null values as zero?
Solution:
@lessorequals(int(coalesce(item().virtualWorkPercentage,0)), 0)
Thanks so much; I wasn't clear.
I need to be able to accept either NULL or 0 (zero); the data from the source comes in a either one.
I appreciate your help!
Thanks!
Mike
So just to clarify, your ask is the column may contain zero or null value?
And in case if the column contains null, we treat it as zero.
Is my understanding correct?
@lessorequals(int(coalesce(item().virtualWorkPercentage,0)), 0)
6 people are following this question.