Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting error in switch Fn

Hi,   I am getting error "The Expression Refers to Multiple Columns. Multiple Columns Cannot Be Converted to a Scalar Value." in below function     Select Metric = IF(ISCROSSFILTERED('Metric '...
Need Help
  • MartynRamsden's avatar
    MartynRamsden
    6 years ago

    Hi Anonymous 

     

    I think you'd be better off using the SELECTEDVALUE function, as per below.

    Select Metric =
VAR SelMetric = SELECTEDVALUE ( 'Metric ' )
VAR Result =
    SWITCH (
        TRUE (),
        SelMetric = "Sales($)", ROUND ( [Select Sales], 0 ),
        SelMetric = "Vol", ROUND ( [Select Trans], 0 ),
        SelMetric = "customers", ROUND ( [Cust], 0 ),
        SelMetric = "Sales Conversion(%)", ROUND ( [Sales Conversion], 0 ),
        SelMetric = "AVG VOL($)", ROUND ( [Avg Vol], 0 ),
        SelMetric = "Exit", ROUND ( [Exit], 0 ),
        BLANK ()
    )
RETURN
    Result

     

    Best regards,
    Martyn

     

MartynRamsden's avatar
MartynRamsden
Solution Sage
6 years ago

Hi Anonymous 

 

I think you'd be better off using the SELECTEDVALUE function, as per below.

Select Metric =
VAR SelMetric = SELECTEDVALUE ( 'Metric ' )
VAR Result =
    SWITCH (
        TRUE (),
        SelMetric = "Sales($)", ROUND ( [Select Sales], 0 ),
        SelMetric = "Vol", ROUND ( [Select Trans], 0 ),
        SelMetric = "customers", ROUND ( [Cust], 0 ),
        SelMetric = "Sales Conversion(%)", ROUND ( [Sales Conversion], 0 ),
        SelMetric = "AVG VOL($)", ROUND ( [Avg Vol], 0 ),
        SelMetric = "Exit", ROUND ( [Exit], 0 ),
        BLANK ()
    )
RETURN
    Result

 

Best regards,
Martyn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Excellent Mate, Thanks Much