I'm attempting to calculate the total of the Money In and Money Out columns. I have defined two functions to accomplish this, but instead of displaying the total at the bottom of the web page, it shows NaN. I'm confused about where I went wrong.
Below is the Angular JS code used:
@{
Layout = null;
}
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.9/angular.min.js"></script>
<script type="text/javascript">
var app = angular.module('MyApp', [])
app.controller('MyController', function ($scope, $http, $window) {
$scope.IsVisible = false;
$scope.Search = function () {
var post = $http({
method: "GET",
url: "http://localhost:52098/HalifaxIISService.svc/TranscationDetails/" + encodeURIComponent($scope.Account_Number),
dataType: 'json',
headers: {
'Accept': 'application/json, text/javascript, */*; q=0.01',
'Content-Type': 'application/json; charset=utf-8'
}
});
post.then(function (response) {
var data = response.data;
$scope.Customers = JSON.parse(data);
$scope.IsVisible = true;
}, function (err) {
$window.alert(err);
});
}
$scope.grandTotal = function () {
return $scope.Customers.reduce(function (previousTotal, m) {
return previousTotal + parseFloat(m.Deposit);
}, 0);
}
$scope.grandTotal1 = function () {
return $scope.Customers.reduce(function (previousTotal, m) {
return previousTotal + parseFloat(m.Withdrawal);
}, 0);
}
});
</script>
<div ng-app="MyApp" ng-controller="MyController">
Account Number:
<input type="text" ng-model="Account_Number" />
<input type="button" value="Submit" ng-click="Search()" />
<hr />
<table style="border: solid 2px Green; padding: 5px;" ng-show="IsVisible">
<tr style="height: 30px; background-color: skyblue; color: maroon;">
<th></th>
<th>Account Number</th>
<th>Money In</th>
<th>Date</th>
<th>Money Out</th>
<th>Date</th>
<th>Account Balance</th>
<th></th>
<th></th>
</tr>
<tbody ng-repeat="m in Customers">
<tr style="height: 30px; background-color: skyblue; color: maroon;">
<td></td>
<td><span>{{m.Account_Number}}</span></td>
<td><span>{{m.Deposit| currency:"£"}}</span></td>
<td><span>{{m.Date}}</span></td>
<td><span>{{m.Withdrawal | currency:"£"}}</span></td>
<td><span>{{m.Date}}</span></td>
<td><span>{{m.Account_Balance| currency:"£"}}</span></td>
</tr>
</tbody>
<table style="border: solid 2px Green; padding: 5px;" ng-show="IsVisible">
<tr style="height: 30px; background-color: skyblue; color: maroon;">
<td>Total Money In:</td>
<td>{{grandTotal()}}</td>
<td>Total Money Out:</td>
<td>{{grandTotal1()}}</td>
<td>Account Balance:</td>
<td>{{m.Account_Balance| currency:"£"}}</td>
</tr>
</table>
</table>
</div>
</body>
</html>
Click here for a visual result of when I run the application: https://i.sstatic.net/8Ru1w.png