New Bug Encountered: Blank screen with EXTRACT() and -LIST("")

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.

Adding @Steve and @praveen

0 1 250
1 REPLY 1

Steve
Platinum 4
Platinum 4

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.

Top Labels in this Space