SOLVED

Table Equations

Copper Contributor

This is probably pretty easy... however I cannot figure it out. I have a table filled with data, and some rows are calculating proportions compared to other rows:

KalebLedonne_0-1588706486435.png

 

I have many blank rows inserted at the bottom of the table for future data entries, however these equations are giving me the divide-by-0 error as there's no data entered yet, obviously. How do I make it so that I can enter new data with the proportions automatically being calculated, but not showing the error while that row is still empty?

 

1 Reply
best response confirmed by KalebLedonne (Copper Contributor)
Solution

@KalebLedonne In this case, use an IFERROR formula to suppress rows where there is no value instead of just dividing the values.

 

=IFERROR([@[Sorter Stop Count]]/[@[Gross Inducts]],"")

1 best response

Accepted Solutions
best response confirmed by KalebLedonne (Copper Contributor)
Solution

@KalebLedonne In this case, use an IFERROR formula to suppress rows where there is no value instead of just dividing the values.

 

=IFERROR([@[Sorter Stop Count]]/[@[Gross Inducts]],"")

View solution in original post