# Override Field with Zeroes

Topic Labels: Formulas
Solved
Jump to Solution
854 1
cancel
Showing results for
Search instead for
Did you mean:
10 - Mercury

Hi all!

I’ve run into an odd issue that I’m hoping someone out there has found a workaround for :slightly_smiling_face:

I have a table consisting of recurring tasks, where each task is assigned a value (\$). A zap creates assignments based on those tasks and values in a separate table.

I need to be able to override the value of the task in the new table; which is pretty straightforward… but I’m running into issues if I want to override the price to be \$0.00. Airtable seems to treat Currency fields (and probably number fields too, haven’t tested it) the same whether they are BLANK() or have a value of \$0.00.

Here is the formula I’m using (in a rollup field):

IF({Override Task Price}, {Override Task Price}, SUM(values)/{Step Count})

Has anyone found a way to force Airtable to recognize ANY entry in a Currency field, even if it’s \$0.00?

1 Solution

Accepted Solutions
10 - Mercury

Geez… spoke too soon! I forced it to view {Override Task Price} as a string by using ARRAYJOIN(), and checked if there’s a value by using LEN().

Here’s the solution that worked for me!

IF(LEN(ARRAYJOIN({Override Task Price})), {Override Task Price}, SUM(values)/{Step Count})
1 Reply 1
10 - Mercury

Geez… spoke too soon! I forced it to view {Override Task Price} as a string by using ARRAYJOIN(), and checked if there’s a value by using LEN().

Here’s the solution that worked for me!

IF(LEN(ARRAYJOIN({Override Task Price})), {Override Task Price}, SUM(values)/{Step Count})