You may add a [Day Number] field in your master calendar which has sequential number for each working day.
Date Day of the week Day Number 6/1/2016 Wednesday 98 6/2/2016 Thursday 99 6/3/2016 Friday 100 6/4/2016 Saturday 6/5/2016 Sunday 6/6/2016 Monday 101 6/7/2016 Tuesday 102 6/8/2016 Wednesday 103 6/9/2016 Thursday 104
If [Day Number] is one less, then it is yesterday.
You can take care of not only the weekends but also your holiday calendar in this approach.
Thanks Everyone !!!
I tried nested if ..here is what I used for the results, I used New Field(Is_Yesterday)in my expressions.
If(Weekday(Today())= 'Mon',if(floor(num(date(Date_D))) =Today()-3,1,0),if (floor(num(date(Date_D))) =Today()-1, 1 , 0)) as Is_Yesterday
Thanks @Marcus Sommer @Varsha Vig @Gysbert Wassenaar @nagaiank