Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a values calculated using variables which are currently shown in a pivot table split by year.
Each of the variables represents a different multiplication factor. How can I add all these up by year and by total ? (i.e. not by resource type)
I know that the calculation below is only multiplying if the resource category matches but I want it to calculate then add it all together but not show the resource categories
if(sum({$<[MPR Project Name]=, [MPR Project Number]=>} if([MPR Source]='Equator', [MPR Weeks] * (vAdjustment/100))) +
sum({$<[MPR Project Name]=, [MPR Project Number]=>} if([MPR Source]='Outsource Capacity', [MPR Weeks]))
-sum(if([MPR Source]='MPR'OR[MPR Source]='Sandbox', if(len([MPR Resource Type])>1, if(left([MPR Resource Type],1)='0' or left([MPR Resource Type],1)='1', [MPR Weeks]))))<0,
(sum({$<[MPR Project Name]=, [MPR Project Number]=>} if([MPR Source]='Equator', [MPR Weeks] * (vAdjustment/100))) +
sum({$<[MPR Project Name]=, [MPR Project Number]=>} if([MPR Source]='Outsource Capacity', [MPR Weeks]))
-sum(if([MPR Source]='MPR'OR[MPR Source]='Sandbox', if(len([MPR Resource Type])>1, if(left([MPR Resource Type],1)='0' or left([MPR Resource Type],1)='1', [MPR Weeks])))))
*if([MPR Resource Type]='01- Concept Engineer',vConceptOutsource,
if([MPR Resource Type]='02- Mechanical (Chassis)'or [MPR Resource Type]='05- Mechanical (Body)',vMechOutsource,
if([MPR Resource Type]='11- Config',vConfigOutsource,
if([MPR Resource Type]='04- Stress Engineer',vStressOutsource,
if([MPR Resource Type]='06- Electrical',vElecOutsource,
if([MPR Resource Type]='09- Test Engineer',vTDEngOutsource,
if([MPR Resource Type]='10- Test Technician',vTDTechOutsource,
if([MPR Resource Type]='08- Homologation',vHomoOutsource,
if([MPR Resource Type]='07- Software',vSoftwareOutsource,
if([MPR Resource Type]='03- Functional Safety & Cyber Security',vFuncSysOutsource,0)))))))))),0)