Last week set analysis

[#1]

How can i use the Weekstart function within a set analysis, so that only the data for last week is included? (I do not mean the last 7 days, i mean the preceding working week.) In this case, I can't adjust my master calendar so have to make do with the CalendarDate field.

This is my expression

=sum({$<Book={"EM MATCH"}>}PRICE)

I can't get my head round the correct syntax

[#2]

Yes, that should work, but it would not update automatically. But even with a binary load, you could add variables in the script.

[MK_QSL]

Check enclosed file...

[#4]

The figure is wrong Manish. The expression for last week (7th - 11th April) should produce the result 72,110

[MK_QSL]

as per the logic your have given, it is right.... i have tasted and uploaded it.

Let us have clarification of your logic.

IF(PURCHASE_SALE='P',-NOMINAL,NOMINAL)*PRICE/100)

[#6]

Strange. Let me investigate

Your help is greatly appreciated

[MK_QSL · Accepted solution]

Check enclosed file showing last week data only...

[#8]

Dirk,

using your eexpression

=sum({$<Book={"EM MATCH"}, Week={$(vLastWeek)}>} PRICE)

I have no field called 'Week'. How are you defining this?

[#9]

Finally got the answer

=sum({$<Book={"EM EUROBONDS VOL MATCH"}>}IF(week(CalendarDate)= week(Today())-1,(IF(PURCHASE_SALE='P',-NOMINAL,NOMINAL)),0)*PRICE/100)

[MK_QSL]

Dear Alex,

Can you please check the answer you are getting using your above mentioned formula?

Also, let me know the answer by formula given to you by myself.

I have used myone and yourone and the result is same !

[#11]

The formula above gives me the correct result. Your formula returned a blank value