Set analysis question

[#1]

Hi ,I am stuck with a set analysis syntax

Now there is a field Daynumber which has data as

1

2

3

.

.

30

and there is a field named ComFlag which has Y and N as values

Now i want to select the max day number which has flag set to Y,

I am trying to do something like

=Max( { <[ComFlag]='Y'>} Daynumber)

But I am getting an error,any idea why ?

thanks for your help

[Anonymous · Accepted solution]

try this

=Max( { <[ComFlag]={'Y'}>} Daynumber)

[Anonymous]

Max( { <[ComFlag]={'Y'}>} Daynumber)  .. curly braces is missing in your syntaxx

[#4]

TY...

[#5]

TY

[#6]

If i have an expression (Actuals/Total)*Forecast and i want to use the date 10 days after the above date.any idea how to modify the equation??

[Anonymous]

cna you post the qvw file with some sample data i can be able to help you .

[#8]

I got it i used =max({<Day_number_in_month={$(=Max( { <[Completed]={'Y'}>} Daynumber) + 10)}>}((Actuals/Total)*Forecast))

[Anonymous]

glad you got it.. Sorry tied up with work. i could not get to you...