Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have an expression like this :
=count({<week_subscription= {"<$(currentweek)"},week_subscription_canceled= {">=$(currentweek)"} + subscription_canceled= {$(=0)} >}employee)
The "+" sign should be read as "OR"
I don't get any results, when I use only one part of the OR statement I do get results so there must be something wrong in the or statement.
Any help ?
I want to compare subscriptions per year
Thanks in advance
May be this:
=Count({<week_subscription = {"<$(currentweek)"}, week_subscription_canceled = {">=$(currentweek)"}> +<subscription_canceled = {$(=0)}>} employee)