Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with Switch case

Hi, I have to add custom column called "score".For that i have to add switch case as below:    CASE WHEN isnull(N_SUM_of_Absolute_us...) THEN 0  WHEN (N_SUM_of_Absolute_us... NOT NULL) and isnul...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Thank you so much.It worked.

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Anonymous , you may apply such a pattern to your measure,

 

Measure = 
SWITCH( TRUE(),
ISNULL(N_SUM_of_Absolute_us...), 0,
ISNULL(Y_SUM_of_Absolute_us...), 1,
round(N_SUM_of_Absolute_us.../(N_SUM_of_Absolute_us... + Y_SUM_of_Absolute_us...), 4)
)

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi CNENFRNL ,

When am trying to apply that it is showing the below error.

Note : Even i changed the table name.still it showing the same error.

Thanks.