Forum Discussion

Allisond's avatar
Allisond
Icon for Advocate II rankAdvocate II
5 years ago
Solved

Using VAR if returns BLANK then next Calculation in Switch True

Good Afternoon,  This is a small sample of what I am trying to do to get a value closest to a date. I have multiple VAR for -29 days, -31 days etc..    Please see below.  My first Result for "Th...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Allisond 

    It's abit complicated to understand but looking at your SWITCH, the order of the logic needs changing.  If ValidRow is True then the 2nd line (ValidRow && ThirtyDWt) will never be evaluated

    Try this

    Return
SWITCH(

TRUE(),

ValidRow && ThirtyDWt = BLANK(), ThirtyMin1Wt,

ValidRow, ThirtyDWt,

BLANK()

)

    Regards

    Phil

Allisond's avatar
Allisond
Icon for Advocate II rankAdvocate II
5 years ago

Ah!   So I have a number of these parameters.  I will try to plug those in this am and use the original last and give it a try this am and get back.  Thank you!

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Allisond 

OK no worries.  Yes, the order of the lines is important.

Regards

Phil

  • Allisond's avatar
    Allisond
    Icon for Advocate II rankAdvocate II
    5 years ago

    I was not leveraging the logic correctly thinking about the "true" and how if false then moves to the next.   Adjusted my statements to 

     

    Valid Row && ThirtyDWt <> BLANK(), ThirtyDWt,

    Valid Row && ThirtyDMin1Wt <> BLANK(), ThirtyDMin1Wt,

    Etc.

     

    And this seemed to take care of it.   Thank you for your help in getting me to think this through.

    • PhilipTreacy's avatar
      PhilipTreacy
      Icon for Super User rankSuper User
      5 years ago

      Hi Allisond 

      If my answers helped to solve your problem please mark my answer(s) as the solution.

      regards

      Phil