0
    
          
  
  
    
            Formula does not display in subtable column: glitch or error?
Hello
I have a formula (see below) that appears to work perfectly, but does not display in the subtable column. Is this a glitch or an error on my part?
Either way, does anyone know a way around it?
Many thanks
Ben
Formula:
if “No. of seeds” = null thennullelse“No. of seeds” / Weightend
(without the formula there are many zeros in the column, which I want to avoid so i can calculate an accurate average of multiple results)
2 replies
- 
  Ben, Try reversing the formula... if “No. of seeds” != null then“No. of seeds” / Weightelsenullend
- 
  Thank you Sean!!! That works perfectly now 
Content aside
- 4 yrs agoLast active
- 2Replies
- 377Views
