Need Help

[paulwalker]

Hi All,

is there any error..??

=count({<Flag={'Opened'}>}, daysDate={{<Flag={'Closed'}>}'$(=Max(Date))'}>} CountID))

[Anonymous]

There are errors.  Can you explain in words what you're trying to do?

[#3]

Hi Paul,

The syntax of the set analysis you are using is wrong.

First define a variable :

Defining a variable:

vdaysDate = Max({<Flag={'Closed'}>}daysDate)

It should be

=count({<Flag={'Opened'},Name={'Test Report'}, daysDate={'$(vdaysDate)'}>} CountID)

Hope this helps.

Regards

[maxgro]

yes,some errors

=count({<Flag={'Opened'}>}{<Name={'Test Report'},............

this should be correct

=count({<Flag={'Opened'},Name={'Test Report'},........

but after that it's difficult to understand your requirement

[Anonymous]

Strangely, a couple of my responses disappeared, together with your replies(?)
Repeating:

I assume you want to count the records for which Name='Test Report' and
either
Flag='Opened'
or
Flag='closed' and daysDate is the latest date.

If so, try:

count({<Name=}'Test Report'}> * (<Flag={'Opened'}> + <Flag={'Closed'}, datesDate={"$(=date(max(datesDate)))"}>)}CountID)