Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
try this
script:
LOAD
Month(Date) as Month,
Num(Month(Date)) as MonthNum,
in front end
count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)
try this
script:
LOAD
Month(Date) as Month,
Num(Month(Date)) as MonthNum,
in front end
count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)
Thank you, it workds, however, I don't undertand why the characters in green here:
count{$<MonthNum ={"<=$(=Num(Month(Today())))"}>} Flag)