I have a report which has a calculation for five different costs:
mechanical, service, damage, elecrical, retro fit, and one for the total of the five.
each expression looks like this (but with its relevant heading in the place of 'Mechanical'):
=Sum([SumOfMechanical])
i need to find the percentage of the total, for each cost (ie mechanical, service etc)
so what i would like to do is: (MechanicalCost/TotalCost)*100
How do i do this?
and will it work building a expression for the percentage ontop of the existing expression.
Many thanks
Devon
mechanical, service, damage, elecrical, retro fit, and one for the total of the five.
each expression looks like this (but with its relevant heading in the place of 'Mechanical'):
=Sum([SumOfMechanical])
i need to find the percentage of the total, for each cost (ie mechanical, service etc)
so what i would like to do is: (MechanicalCost/TotalCost)*100
How do i do this?
and will it work building a expression for the percentage ontop of the existing expression.
Many thanks
Devon
