Forum Discussion
Allisond
Advocate II
Advocate IIUsing 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...
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
PhilipTreacy
Super User
Super UserHi 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