Is it possible to get the actuals from the max Date -1.

[#1]

Is it possible to get the actuals from the max Date -1.

So in this case I only want to see 15 from 23-09-2010.

What Syntax did I have to use?

Date	Actuals
21-9-2010	10
22-9-2010	20
23-9-2010	15
24-9-2010	25

[Miguel_Angel_Baeyens]

Hello,

First, format your date in your load script so

Date(Date#(Date, 'DD-M-YYYY')) AS Date

Then you should use something like

Only({< Date = {"$(=Max(Date(Date)) -1)"} >} Actuals)

Hope that helps

[#3]

Miguel,

Normally for years I use this syntax

Sum({$<Year={$(=Max(Year)-1)}>} Actuals)

The problem is the date you use. He don't recognize the date.

[Miguel_Angel_Baeyens]

Hi,

Is the script loaded with date formatted as suggested above?

If not, it won't work, since date() function needs formatting to match properly.

Regards.

[#5]

Miguel,

I used the following syntax:

Date

(Date, 'DD-M-YYYY') AS Date

=

Sum({< Date = {"$(=Max(Date(Date) -1))"} >} Actuals)

I don't understand why you use the Date#?

[#6]

Miguel,

Is it possible to send you the .qvw file?

[Miguel_Angel_Baeyens]

Hi,

Date# is needed since your Date field needs to be formatted according to your values.

You can upload files in your post, or in your profile and paste the link here.

Regards