multiply a factor by number of rows

Rasmus Jensen ·

Is it possible to multiply a factor by the number of rows in a table? 

For example say that every time a robot does a job, it comes up as a row in the table (one job equals one row), meaning that the number of rows will continue to grow. 
Every time a job is done by the robot it saves 60 minutes of company time. 

Is it possible to make a syntax that multiplies: 60 x "number of rows", and so that the result always shows the minutes saved all in all?

0

Comments

1 comment
Sort by DateVotes
  • Ole Dyring

    Hi Rasmus,

    You can calculate the number of rows like this:

    allcount(d1, all, m1)

    And multiply by any factor you like:

    60 * allcount(d1, all, m1)

    BR / Ole 

    0
Please sign in to leave a comment.