This content has been marked as final.
Show 3 replies
-
Re: Use Slider range in an expression
Antonio Mancini Jul 19, 2017 4:44 PM (in response to Joe Mathews)Hi Joe,
try this
=Num(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'}>} country),'###,##0')
Regards,
Antonio
-
Re: Use Slider range in an expression
Joe Mathews Jul 19, 2017 6:30 PM (in response to Antonio Mancini)Thanks.
How can I add one more condition into the above Expressions.
Like a column called 'approved' That has values 'Y' or 'N'. And I want to include only the approved ='Y' in the above count.
-
Re: Use Slider range in an expression
Antonio Mancini Jul 20, 2017 12:26 AM (in response to Joe Mathews)=Num(Count({<begindate={'>=$(=Min(Date([Month Year])))'},enddate={'<=$(=Max(Date([Month Year])))'},approved={'Y'}>} country),'###,##0')
-
-