Macro Multiple Filtration

Hi Guys,

I am trying to filter product in opportunity based on location and sum the total for that location, then display it in printable template. Here is my code but its giving me three rows instead of just one. Please help

namespace Terrasoft.Configuration
{
    using System;
    using System.CodeDom.Compiler;
    using System.Collections.Generic;
    using System.Data;
    using System.Linq;
    using System.Runtime.Serialization;
    using System.ServiceModel;
    using System.ServiceModel.Web;
    using System.ServiceModel.Activation;
    using System.Text;
    using System.Text.RegularExpressions;
    using System.Web;
    using Terrasoft.Common;
    using Terrasoft.Core;
    using Terrasoft.Core.DB;
    using Terrasoft.Core.Entities;
    using Terrasoft.Core.Packages;
    using Terrasoft.Core.Factories;
    
    [ExpressionConverterAttribute("AtsGetLocationProductsSum")]
    class OpportunityProductSumByLocation : IExpressionConverter
    {
        private UserConnection _userConnection;
        
        public string Evaluate(object value, string arguments = "")
        {
            try
            {
                _userConnection = (UserConnection)HttpContext.Current.Session["UserConnection"];
                Guid locationId = new Guid(value.ToString());
                return getLocationProductsSum(locationId);
            }
            catch (Exception err)
            {
                return err.Message;
            }
        }
        private string getLocationProductsSum(Guid locationId)
        {
            try
            {
                EntitySchemaQuery esq = new EntitySchemaQuery(_userConnection.EntitySchemaManager, "OpportunityProductInterest");
                var AtsSumProduct = esq.AddColumn(esq.CreateAggregationFunction(AggregationTypeStrict.Sum, "AtsLineTotal"));
                var filter = esq.CreateFilterWithParameters(FilterComparisonType.Equal, "AtsLocation.Id", locationId);
                esq.Filters.Add(filter);
                EntityCollection entities = esq.GetEntityCollection(_userConnection);
                if (entities.Count > 0)
                {
                    return entities[0].GetTypedColumnValue(AtsSumProduct.Name).ToString();
                }
                return "0";
            }
            catch (Exception err)
            {
                throw err;
            }
        }
    }
}