Problem with network days

[#1]

Hello!

I need not consider Saturdays and Sundays in my qv document. I have to calculate the data of yesterday, but when today is Monday i want to calculate data of Friday.

Thank you for your help!!!

[#2]

Thanks but not work.

[#3]

More ideas???

[simondachstr]

FirstWorkDate(today(),2)) will give you your desired date. Now your issue is not getting the right work date, but correctly applying the set analysis expression to your [Day] field.

I've suggested two options based on the information that you have made available, which are working in my local test example, but apparently do not work in your case.

The only way now to help you is if you could upload a sample qvw file of your data.

[#5]

Sorry, but i can`t. do that

I've did this:

=if(DayW<>'Monday',num(count({$<Day={$(=Max(Day)-1)},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2),'#.##0,00'),num(count({$<Day={$(=Max(Day)-3)},[name]={'BOOK'},[id]={1},[ip]={7}>}distinct id_2),'#.##0,00')

But when is 02/10/2014 or 01/10/2014 the result is -, what is the problem?

Thank you!!!

[#6]

Any ideas?

Thank you.