Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day
I would like to link the below two calculations into one formula to be used my in measure(for my line graph):
calc 1: =if(match(ContractName,'X110 - PPC SLURRY','X120 - PPC DWAALBOOM','X260 - DISTELL GP','X260 - DISTELL GP MANAGED','X270 - DISTELL CAPE TOWN','X270 - DISTELL CAPE TOWN MAANGED','CCL McCain Transport','X360 - ISANTI','X370 - EVERITE','X380 - MERENSKY','X390 - SAFRIPOL','X400 - CAPE TOWN LOCAL','X410 - LANGENI','X500 - OWNER DRIVERS','X500 - RELIEF DRIVERS','X510 - Refrigerated O/D (Trucks)','X575 - FIXED SUBCONTRACTORS','X600 - NEOGISTIX','X740 - NEOGISTIX NAMIBIA','X745 - NEOGISTIX SAFRIPOL','X999 - DEPOT SUPPORT','HVL' ),ContractName)
Calc 2: sum(TripFuel)/sum(TripDistance)*100
Hope this makes sense
Kind Regards
Hi,
Is not really clear what you want to do, could it be you want to include just those ContractName in the sum, if so then include as set analysis;
sum({<ContractName={'your list'}>}TripFuel)/sum({<ContractName={'your list'}>}TripDistance)*100
Maybe?
Cheers,
Chris.
Hi,
Is not really clear what you want to do, could it be you want to include just those ContractName in the sum, if so then include as set analysis;
sum({<ContractName={'your list'}>}TripFuel)/sum({<ContractName={'your list'}>}TripDistance)*100
Maybe?
Cheers,
Chris.