SOLVED

Table Equations

%3CLINGO-SUB%20id%3D%22lingo-sub-1361272%22%20slang%3D%22en-US%22%3ETable%20Equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361272%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20probably%20pretty%20easy...%20however%20I%20cannot%20figure%20it%20out.%20I%20have%20a%20table%20filled%20with%20data%2C%20and%20some%20rows%20are%20calculating%20proportions%20compared%20to%20other%20rows%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KalebLedonne_0-1588706486435.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189215iCB8531B456F888AA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22KalebLedonne_0-1588706486435.png%22%20alt%3D%22KalebLedonne_0-1588706486435.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20many%20blank%20rows%20inserted%20at%20the%20bottom%20of%20the%20table%20for%20future%20data%20entries%2C%20however%20these%20equations%20are%20giving%20me%20the%20divide-by-0%20error%20as%20there's%20no%20data%20entered%20yet%2C%20obviously.%20How%20do%20I%20make%20it%20so%20that%20I%20can%20enter%20new%20data%20with%20the%20proportions%20automatically%20being%20calculated%2C%20but%20not%20showing%20the%20error%20while%20that%20row%20is%20still%20empty%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1361272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1361375%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20Equations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F656769%22%20target%3D%22_blank%22%3E%40KalebLedonne%3C%2FA%3E%26nbsp%3BIn%20this%20case%2C%20use%20an%20IFERROR%20formula%20to%20suppress%20rows%20where%20there%20is%20no%20value%20instead%20of%20just%20dividing%20the%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(%5B%40%5BSorter%20Stop%20Count%5D%5D%2F%5B%40%5BGross%20Inducts%5D%5D%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted
Best Response confirmed by KalebLedonne (Occasional Visitor)
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]],"")