Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF Statement taking too long to execute

Hi,   I have created a multiple IF statement but the statement is taking too long to execute, is there a way around this? My measure: Trend = IF([Count Negative Results] = 6, "Losing", IF([C...
Need Help
  • mwarren's avatar
    mwarren
    7 years ago

    Have you tried using 'SWITCH'?

     

    Trend = SWITCH( TRUE() ,
    [count negative results] = 6 , "Losing" ,
    [count negative results] in {3,4,5} && [Average Moving and CY TTM] <= -.6 , "Losing" , 

    etc....

     

    This has sped up my nested IF statements in the past.

     

  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Have you tried making a call the measures and storing as variables outside of the IF/SWITCH ?

     

    Trend = 
var __CountNeg = [Count Negative Results]
var __AvgMov = [Average Moving and CY TTM]

RETURN

SWITCH(TRUE(),
__CountNeg = 6, "Losing", 
__CountNeg in {3,4,5} && __AvgMov <= -.6 ,"Losing", 
...

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey,

 

Thanks for the above inputs, I have different measures and i am counting the frequency of negative values of those measure. I dont find any other way to add these measures, please help!

 

Count Negative Results = IF([TTM Var 1] < 0,1,0) + IF([TTM Var 2] < 0,1,0) + IF([TTM Var 3] < 0,1,0) + IF([TTM Var 4] < 0,1,0) + IF([TTM Var 5] < 0,1,0) + IF([TTM Var 6] < 0,1,0)
 
Using If statement is the problem here for large computational time, please guide me if there is a way around.
 
Thanks!
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
7 years ago

Have you tried making a call the measures and storing as variables outside of the IF/SWITCH ?

 

Trend = 
var __CountNeg = [Count Negative Results]
var __AvgMov = [Average Moving and CY TTM]

RETURN

SWITCH(TRUE(),
__CountNeg = 6, "Losing", 
__CountNeg in {3,4,5} && __AvgMov <= -.6 ,"Losing", 
...

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Worked like a charm! Thank you all!

    • TomMartens's avatar
      TomMartens
      Icon for Super User rankSuper User
      7 years ago

      Hey Anonymous,

       

      please mark the most helpful post as an answer, as it also helps others in this forum.

       

      Regards,

      Tom