current day

[Anonymous]

Hello everyone!

I am back again with another query.  I could not seem to find the right expression for my project.

what I want is to get the data total hours of current or latest DAY in my file.

I have used below expression but is giving me zero "0" value.

attached is the sample.

my objective is to get the data per tester on a daily basis (see attached picture)

[tresesco]

Try:

SUM({<OEE={'*UP*'}, WORKWEEK={$(=Max(WORKWEEK))},DAY={$(=WeekDay(Max(DATE)))}  >}HRS)

[pooja_prabhu_n]

Hi,

DAY is in text format, try Maxstring instead of Max(Day)

SUM({<OEE={'*UP*'}, WORKWEEK={$(=Max(WORKWEEK))}, DAY={$(=MaxString(DAY))} >}HRS)

Thanks,

Pooja

[Anonymous]

Hi Pooja,

thanks for your help, I did try both your formula and below is my observation.

the second one using maxstring is giving me the previous day data.

while the first one gives the correct data that I need.

thank you so much!

[Anonymous]

Hi Tresesco,

Your formula perfectly works!

thanks a lot...