Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Argument '18' in SWITCH function is required.

Hi All,
Getting error as -  "Argument '18' in SWITCH function is required"


case1 = SWITCH(TRUE(),
Metrics[Methodology-project_type] = "Agile",
(SWITCH(TRUE(),Metrics[MyWizard_Metric_Name] = "Sprint" &&
(isblank([MetdefAgile_Sprint_Velocity_Ratio_Agile--overall&auto])||[MetdefAgile_Sprint_Velocity_Ratio_Agile--overall&auto]= "")
&&[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","One"} &&
Metrics[MyWizard_Metric_Value]<> BLANK(),1,
--
Metrics[MyWizard_Metric_Name] = "Rework" && ([MetdefAgile_Cost_of_Rework_Agile-overall&auto] = blank() ||
[MetdefAgile_Cost_of_Rework_Agile-overall&auto] = "")&&
[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"} && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Overall" && ([MetdefAgile_Overall_Defect_Rate-overall&auto] = blank()||
[MetdefAgile_Overall_Defect_Rate-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
ISBLANK([N/A]) && Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Automation" &&([MetdefAgile_Test_Automation_Penetration-overall&auto] = blank() ||
[MetdefAgile_Test_Automation_Penetration-overall&auto] = "") &&
[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"}
&& [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Testing" && ([MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = blank()
||[MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
ISBLANK([N/A]) && Metrics[Agile-cond] ="All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Test",([MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = blank()
||[MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
&& Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Test1",([MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto]= blank()
||[MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
&& Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,)),
)

please suggest on this error, how to fix

1 Reply

  • Anonymous , Try like

     

    SWITCH(TRUE(),
    Metrics[Methodology-project_type] = "Agile",
    SWITCH(TRUE(),Metrics[MyWizard_Metric_Name] = "Sprint" &&
    isblank([MetdefAgile_Sprint_Velocity_Ratio_Agile])||[MetdefAgile_Sprint_Velocity_Ratio_Agile--overall&auto]= "")
    &&[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","One"} &&
    Metrics[MyWizard_Metric_Value]<> BLANK(),1,
    --
    Metrics[MyWizard_Metric_Name] = "Rework" && ([MetdefAgile_Cost_of_Rework_Agile-overall&auto] = blank() ||
    [MetdefAgile_Cost_of_Rework_Agile-overall&auto] = "")&&
    [MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"} && [MyWizard_Metric_Value]= blank(),1,
    --
    Metrics[MyWizard_Metric_Name] = "Overall" && ([MetdefAgile_Overall_Defect_Rate-overall&auto] = blank()||
    [MetdefAgile_Overall_Defect_Rate-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
    ISBLANK([N/A]) && Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
    --
    Metrics[MyWizard_Metric_Name] = "Automation" &&([MetdefAgile_Test_Automation_Penetration-overall&auto] = blank() ||
    [MetdefAgile_Test_Automation_Penetration-overall&auto] = "") &&
    [MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"}
    && [MyWizard_Metric_Value]= blank(),1,
    --
    Metrics[MyWizard_Metric_Name] = "Testing" && ([MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = blank()
    ||[MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
    ISBLANK([N/A]) && Metrics[Agile-cond] ="All" && [MyWizard_Metric_Value]= blank(),1,
    --
    Metrics[MyWizard_Metric_Name] = "Test",([MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = blank()
    ||[MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
    && Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
    --
    Metrics[MyWizard_Metric_Name] = "Test1",([MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto]= blank()
    ||[MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
    && Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1
    ) )

     

     

    But might need sample file to test