set analysis date field

[#1]

Hi all,

I need help for the attached file.

I have 2 expressions I need.

1. sum(VALOARE) I need the result for a selected DATA formated in Date.

2. sum({$<{if(weekday(DATA)=0, DATA-1, DATA-2)}>} VALOARE): wich is sum of VALOARE for previous day (or satterday if selected date is Monday).

It does not work for a date formated as date. I need it like this as it is important for the other objectys in document

Can you help?

Regards,

John

[SunilChauhan]

may be like this

please see tthe attached file

[#3]

thanks and regards.

[#4]

Unfortunatelly  your sollution does not return the right result. While different from zero in mine, the result in all the formulas is not the one for the actual date I want to have but for the selected date.

Thanks anyway. It is a good point to work on further...

John

[gandalfgray · Accepted solution]

I gave it a try also, but I stopped after the first two set-columns in the table since  it is not clear to me what you want to achieve with the rest of them.

I cloned the table so my expressions are in the table below the original

You can have a look anyway...

/gg

[#6]

The rest of the columns were just traials in order to achieve what I wanted.

It seems ok. Thanks a lot.

Regards,

J