This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Unable to get a blank field for an initial value

Posted on 07-01-2020 09:17 PM
Daisy_Ramirez
Silver 5
Silver 5
Reply posted on --/--/---- --:-- AM

Hi everyone, I’ve been trying to use the expression below to get a blank initial value in my field name “Shoes” if another field Weight Collected is not 0 or if it has a value but unfortunately “Shoes” continues to default to 0. Is the expression seems to be pretty straight forward but not sure why its not responding with a blank field when I input a value in Weight Collected.

If(OR([Weight Collected]=0,ISBLANK([Weight Collected])),0," ")

3X_f_3_f33c95b9945c41da06b667f3521b85ba9c1003b9.png

0 6 515
Topic Labels
0 Likes
6 REPLIES 6
Top Labels in this Space