Hello. I am trying to add new fields to my table by using an aggregation.
Goal is to add 2 (up to 6) additional columns to give a higher overview of the customers as a whole for my table.
This is what I have below. The code runs, but when I look at my table the new field is there, but it only shows - in every row. Which I know is not true. Why isn't it summing the fields for me?? Thanks in advance!
CustomerTotals:
LOAD PLC_CustomerID
FROM
[lib://3_QVD_Generators\4_QVDs\InsuranceComm_Policy.qvd]
(qvd);
inner join (CustomerTotals)
load PM_CustomerID as PLC_CustomerID, sum(PLC_EarnedReserve) as TotalEarnedReserve
FROM
[lib://3_QVD_Generators\4_QVDs\InsuranceComm_PolicyMoney.qvd]
(qvd)
GROUP BY PM_CustomerID;
left join (CustomerTotals)
Load CL_CustomerID as PLC_CustomerID, sum(CL_SettlementAmount) as TotalLosses, Count(if(CL_SettlementAmount>0,CL_ClaimNumber)) AS TotalPaidCount, sum(CL_Reserve) as TotalClaimReserves
FROM
[lib://3_QVD_Generators\4_QVDs\InsuranceComm_Claims.qvd]
(qvd)
GROUP BY CL_CustomerID;
left join (CustomerTotals)
Load CLA_CustomerID as PLC_CustomerID, sum(CL_Salvage) as TotalSalvage
FROM
[lib://3_QVD_Generators\4_QVDs\InsuranceComm_ClaimAssets.qvd]
(qvd)
GROUP BY CLA_CustomerID;
