DECIMAL(INDEX(EXTRACTPRICES([OCRTEXT]),6))
is working fine
DECIMAL(INDEX(EXTRACTPRICES([OCRTEXT])-LIST(""),6))
is producing a blank screen in the form when you add a new row.
My goal is to remove prices with no value. I can’t use UNIQUE(), because I don’t want to remove duplicates.
Unfortunately, list subtraction (e.g., ... - LIST("")
) will remove duplicates as well. I don’t know a way to preserve duplicates while also removing blanks. Though I’d be surprised that EXTRACTPRICES() would produce a list that includes blanks…
I have no idea what’s causing the blank screen.
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |