Jump to content


Recommended Posts

Confused on why my toFixed(2) function is not rounding my output. Located at the bottom of my code here. My output is "501327.3600770543"

//// Get the sq inch. for BuildIDs that start with AA and 
//// sets value to the "result" variable
var result=0;
var params = {
	maxItems: 100000 /* NUMBER */

//// result: INFOTABLE
var itPartInfo = Things["Training.InfoTable.PartInfo"].GetDataTableEntries(params);

// Return square inches of Oak needed for each build ID that starts with AA
// Like type filters by a like criteria
// filters rows from Infotable PartInfo
var query = {
  filters: {
    "type": "AND",
        "fieldName": "BuildID",
        "type": "LIKE",
        "value": "AA*"
        "fieldName": "MaterialType",
        "type": "EQ",
        "value": "Oak"
var oakparams = {
	t: itPartInfo /* INFOTABLE */,
	query: query /* QUERY */

// result: INFOTABLE
var sqresult = Resources["InfoTableFunctions"].Query(oakparams);

//Infotable for loop snippet
var tableLength = sqresult.rows.length;

// for loop will loop through itPartInfo, calculate the sq. in. for each part that starts with AA and return 
// sq. in. in "result"
for (var x = 0; x < tableLength; x++) {
	var row = sqresult.rows[x];
    	//Your code here
    	//+= addition assignment operator is basically same as "x = x + y"
    result += (row.Height*row.Width);


Edited by chob1234
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...