Formulas that operate only with numbers cannot read numbers from cells

Formulas that operate only with numbers cannot read numbers from cells

Posted by: pavloboiko on 19 December 2022, 5:04 am EST

• 

  pavloboiko

  • Post Options:
  • Link
    Copy

  Posted 19 December 2022, 5:04 am EST - Updated 19 December 2022, 5:09 am EST

  If I’m trying to use a formula that operates only with numbers ( ex. AVERAGE() ) - it shows me error #DIV/0!, but if I’m trying to use for example SUM() with the same cell numbers, everything works perfectly. Also if I use COUNT() for these cells it returns 0.
  
  

  

  1338×302 19.4 KB

  
  
  The numbers are also broken when exporting them to excel.
  
  The formatter that was used - “($* #,##0.00;($* (#,##0.00)”

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 20 December 2022, 7:59 am EST

  Hi,

  Could you please share sample JSON file so that we could investigate further and help you accordingly.

  Regards,
  
  Avinash

• 

  jeanaukajkarns3744

  • Post Options:
  • Link
    Copy

  Posted 20 December 2022, 7:20 pm EST

  error occurs when there are no “matching” values. This is due to the fact that count might occasionally be 0 and the general formula for computing averages is =sum/count.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 21 December 2022, 5:02 am EST - Updated 21 December 2022, 5:07 am EST

  hi,

  We are sorry but we test the online designer and there it is working fine. Please share a working sample ssjson file that replicates the issue so that we could investigate it further and help you accordingly.

  Regards,
  
  Avinash

  

  818×451 34 KB

• 

  pavloboiko

  • Post Options:
  • Link
    Copy

  Posted 16 February 2023, 9:29 am EST

  Sure, here is the json of the table that has this strange behaviour.
  
  example.json.zip

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 17 February 2023, 6:33 am EST - Updated 17 February 2023, 6:39 am EST

  Hello,
  
  We opened the json file provided by you in the SpreadJS designer and there is no problem with AVERAGE function used in cell B6. Please let us know if we are missing any steps to reproduce the issue on our end so that we can provide solution to resolve the issue you are facing.
  
  Here is a demo of steps we took.

  regards,