Copying value from different column - complex formula

On 08/22/2022 at 11:39

Good morning,

I am trying to create a new column ( example below" created " column is the result I would like to get ). The new column should copy the value of the " DEN" column for each KPI ( taking into account the MARKET except for the KPI "NNS Aff" where it should change the value instead of zero it should take the value of NNS for the appropriate market.

There is many different markets so the formula should take the market into consideration.

Best regards,
A.

KPI time Cluster Sub cluster Market C B. A num num-calc den den-c created

NNS2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition5819,9135819,913000
Sales PFME2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition240,0538240,05385819,91305819,913
FFOH2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition698,0702698,07025819,91305819,913
FFOH Int2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition538,5705538,57055819,91305819,913
PRO2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition-145,042-145,0425819,91305819,913
PRO Int2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition-156,0896-156,08965819,91305819,913
Dep FF2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition78,023778,02375819,91305819,913
Dep FF Int2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition101,4998101,49985819,91305819,913
OPFE2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition26,238126,23815819,91305819,913
Bad Goods2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition6,62696,62695819,91305819,913
PC2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition2290,44452290,44455819,91305819,913
FDC2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition153,2392153,23925819,91305819,913
Structural Costs2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition1332,28861332,28865819,91305819,913
NNS Aff2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition2189,49622189,4962005819,913
OP1 Aff2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition183,6664183,66642189,496202189,4962
Volumes2021 YTD - 02AOA ClusterOceaniaOceaniaMNMedical Nutrition616616000
Search for threads similar to "copying value different column complex formula"