Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
is there any error..??
=count({<Flag={'Opened'}>}, daysDate={{<Flag={'Closed'}>}'$(=Max(Date))'}>} CountID))
There are errors. Can you explain in words what you're trying to do?
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
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
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)