Add multiple running total script into one script

Question

Hello,I'm using this running total script which works great but I want to add another running total column based on another field to this. Any solutions on how to add another running total in the same script?The table and view are the sameThe fields would be different (Field Pillar & Domain is the same but instead of Q2 Demand it would be Q3 Demand)The sort would be the sameRunning total field would be Q3 Running Demand let table = base.getTable('Resource Capacity Planning');
let view = table.getView('Capacity Planning Include Only');
let result = await view.selectRecordsAsync({
  fields: ['Pillar & Domain','Q2 Demand'],
  sorts: [ {field: 'Pillar & Domain'}, {field: "Stack Rank"}]});
let runningTotal = 0;
let currentGrouping='';

for (let record of result.records) {
    if (currentGrouping !=record.getCellValueAsString('Pillar & Domain')) {
  currentGrouping=record.getCellValueAsString('Pillar & Domain');
  runningTotal = 0  }
    runningTotal += record.getCellValue('Q2 Demand');
    await table.updateRecordAsync(record, {
        'Q2 Running Demand': runningTotal,
    });
} Thank you!

TheTimeSavingCo · Accepted Answer

Probably something like:let table = base.getTable('Resource Capacity Planning');let view = table.getView('Capacity Planning Include Only');let result = await view.selectRecordsAsync({  fields: ['Pillar & Domain','Q2 Demand', 'Q3 Demand'],  sorts: [ {field: 'Pillar & Domain'}, {field: "Stack Rank"}]});let q2RunningTotal = 0;let q3RunningTotal = 0;let currentGrouping='';for (let record of result.records) {    if (currentGrouping !=record.getCellValueAsString('Pillar & Domain')) {      currentGrouping=record.getCellValueAsString('Pillar & Domain');      q2RunningTotal = 0;       q3RunningTotal = 0;      }    q2RunningTotal += record.getCellValue('Q2 Demand');    q3RunningTotal += record.getCellValue('Q3 Demand');    await table.updateRecordAsync(record, {        'Q2 Running Demand': q2RunningTotal,        'Q3 Running Demand': q3RunningTotal,    });}

Ann_Yeom · Answer

Probably something like:let table = base.getTable('Resource Capacity Planning');let view = table.getView('Capacity Planning Include Only');let result = await view.selectRecordsAsync({  fields: ['Pillar & Domain','Q2 Demand', 'Q3 Demand'],  sorts: [ {field: 'Pillar & Domain'}, {field: "Stack Rank"}]});let q2RunningTotal = 0;let q3RunningTotal = 0;let currentGrouping='';for (let record of result.records) {    if (currentGrouping !=record.getCellValueAsString('Pillar & Domain')) {      currentGrouping=record.getCellValueAsString('Pillar & Domain');      q2RunningTotal = 0;       q3RunningTotal = 0;      }    q2RunningTotal += record.getCellValue('Q2 Demand');    q3RunningTotal += record.getCellValue('Q3 Demand');    await table.updateRecordAsync(record, {        'Q2 Running Demand': q2RunningTotal,        'Q3 Running Demand': q3RunningTotal,    });}This is perfect! Thank you Adam! &#128077;

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded