[ASK] how to count today value with previous day value (office day)

[#1]

hello..

i have a problem here

i have two qvd whic is one for today value and one is for yesterday value

and our office day is around monday to friday

so when it meet monday, it should count monday value with friday value

if the case is another day, like tuesday, i can count tuesday value with monday value

but when i meet monday, it count with sunday value which is there is no value in that day

how to do count monday value with yesterday value that is friday?

many thx...

[#2]

no one?

😞

[jarebpat]

Hello Randy,

Did you ever get this figured out? I had to use the same logic but had some problems....

I had to switch between 2 expressions depending on if its a Monday or a Tue,Wed,Thu,Fri, because we're looking back a day, and on Monday's we're looking back 3 days or last business day.

This worked for me:

=if(weekday(Today())='Mon',day(LastWorkDate(WeekStart(Date(today()-1)), 5)),

day(date(LastWorkDate((Today()-1),1,$(vHolidayList)),'MMM/DD/YYYY')))

with this expression, I set an action "Select in Field" for my day and put that expression as my search string, so now it picks up the corresponding day.

Jareb