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.
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |