nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

667407_en-US

liliconcom

Trying to create a column and fill it with a formula but I get an error.

Hi, I can make the script to fill the new column created.

This is the error I get:
Has anyone an idea of whats wrong here?

Formula Interrupted
Cannot convert argument to a number [or matrix] at row 1 in access or evaluation of 'Subtract' , Column( j ) - /*###*/Column( j + 1 ) /*###*/
Formula evaluation errors have been ignored

Hi, I can make the script to fill the new column created.This is the error I get: Has anyone an idea of whats wrong here?Formula InterruptedCannot convert argument to a number [or matrix] at row 1 in access or evaluation of 'Subtract' , Column( j ) - /*###*/Column( j + 1 ) /*###*/Formula evaluation errors have been ignored

For (j=3, j<=10, j=j+2,
 
 ColLen=Length(Char(Column name (j)));
 ColName=Left (Char(Column Name(j)),ColLen -5);
 NewCol=Substr(ColName,6);
 
 New Column(
  "Delta: "||NewCol,
  Numeric, 
  Formula (
   (Column (j)- Column(j+1))
  )
 )
);

Automation and Scripting

Comments

Quick Links