
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to make a COunt If, when month is smaller tha a given month
Hello
I want to make a count If for flags, If flag has been received before a given month
The following one is OK, but that's not what I want
Count({<[Global Date]=10>}[FLAG])
This one is not working
Count({<[Global Date]<=10>}[FLAG])
Neither this one
Count({<Month([Global Date])=10>}[FLAG])
And of course nor this one
Count({<Month([Global Date])<=10>}[FLAG])
What shall I do ?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
script:
LOAD
Month(Date) as Month,
Num(Month(Date)) as MonthNum,
in front end
count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try this
script:
LOAD
Month(Date) as Month,
Num(Month(Date)) as MonthNum,
in front end
count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, it workds, however, I don't undertand why the characters in green here:
count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)
