|
D
denspad author
Hi All,
I have a PHP runner project with a table called 'projects' in it. Within this table are two fields 'Estimated_ProjectValue' and 'Project_Profitability_Pounds'. When I am in 'List View' I want the list to display an additional column that is a calculation based on the values in these two fields. The new field should be labelled 'Project_Profitability_Percent' and should be the result of 'Project_Profitability_Pounds / Estimated_ProjectValue'.
My current SQL code for the table is shown below
SELECT
tblprojects.ProjectNo,
tblprojects.ProjectName,
tblprojects.ProjectTotalMetres2,
tblprojects.ProjectFirstContact,
tblprojects.StatusID,
tblprojects.WorksTypeID,
tblprojects.WaterProofingID,
tblprojects.OriginalSystemID,
tblprojects.PlantingTypeID,
tblprojects.InstalledSystemID,
tblprojects.ProjectCompletionDate,
tblprojects.MaintenanceRequired,
tblprojects.ArchiveID,
tblprojects.MarketSegmentID,
tblprojects.ProjectAddressLine1,
tblprojects.ProjectAddressLine2,
tblprojects.ProjectPostcode,
tblprojects.ProjectTown,
tblprojects.ProjectCounty,
tblprojects.ProjectCountry,
tblprojects.Expected_Delivery_Date,
tblprojects.Estimated_ProjectValue,
tblprojects.Chance_Of_Winning,
tblprojects.Project_Profitability_Pounds,
tblprojects.Kalzip_Commission_Percent,
tblprojects.WorkingHeightID
FROM tblprojects
LEFT OUTER JOIN tblprojectstatus ON tblprojects.StatusID = tblprojectstatus.StatusID
LEFT OUTER JOIN tblworkstype ON tblprojects.WorksTypeID = tblworkstype.WorksTypeID
LEFT OUTER JOIN tblwaterproofingtype ON tblprojects.WaterProofingID = tblwaterproofingtype.WaterProofingID
LEFT OUTER JOIN tblsystem ON tblprojects.OriginalSystemID = tblsystem.SystemID
LEFT OUTER JOIN tblsystem AS system2 ON tblprojects.InstalledSystemID = system2.SystemID
LEFT OUTER JOIN tblplantingtype ON tblprojects.PlantingTypeID = tblplantingtype.PlantingTypeID
LEFT OUTER JOIN tblarchivebox ON tblprojects.ArchiveID = tblarchivebox.BoxID
LEFT OUTER JOIN tblmarketsegment ON tblprojects.MarketSegmentID = tblmarketsegment.MarketSegmentID
LEFT OUTER JOIN tblworkingheight ON tblprojects.WorkingHeightID = tblworkingheight.HeightID
ORDER BY tblprojects.ProjectNo DESC
Can anyone help me with how to integrate this calculation into the code? Somebody helped me out with the following code (below) but I cannot get it integrated into the code above without the same value calculated for the first record, appearing on every record. Can anyone help it's driving me mad!
(select sum(Project_Profitability_Pounds / Estimated_ProjectValue ) AS `Profitability_Percent` from tblProjects)
Kind Regards,
|
|