I have this table in an email notification using an email script that is populated via GlideRecord query.
I want to take the “Total Amount” column and add it in the total. I have the “total amount” being populated by multiplying rate (gr.time_sheet.u_adjusted_rate) x hours (gr.total). Total Amount = roundedPay.
I want to just add up all the “roundedPay” and add it in the empty cell. I am not sure how to do this since it is a new variable and not directly from the query. Below is my code (that is not working). Any ideas how I can accomplish this?
var gr=new GlideRecord('time_card');
gr.addQuery('time_sheet', current.sys_id);
gr.addQuery('category','Straight Time');
gr.orderBy('u_date');
gr.query();
var StraightTotal = new GlideAggregate ('time_card');
StraightTotal.addQuery('time_sheet', current.sys_id);
StraightTotal.addQuery('category', 'Straight Time');
StraightTotal.setGroup(false);
StraightTotal.addAggregate('SUM','total');
StraightTotal.query();
//gs.log('Total '+ parseFloat(straightTime).toFixed(2));
if(StraightTotal.next()){
gs.info('SUM: ' + StraightTotal.getAggregate('SUM', 'total'));
}
while(gr.next()){
var straightTime = StraightTotal.getAggregate('SUM', 'total');
var Total = parseFloat(straightTime).toFixed(2);
var rate = gr.time_sheet.u_adjusted_rate;
var hours = gr.total;
var pay = rate * hours;
var roundedPay = parseFloat(pay).toFixed(2);
var TotalAmount = roundedPay;
var obj = JSON.parse(roundedPay);
var nums = [];
var tot = 0;
for (var i=0; i<obj.length; i++){
tot += parseFloat(obj[i]);
}
1 ACCEPTED SOLUTION
