Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i need to show data until selected year and Month
have Joining date till the selected year moth need to know number of employees
tried build two variables
1.vYear ==passing selected year
2. vMonth =passing selected Month
3. concatenation both variables vyearmonth =vYear &vMonth
have column year(joinng date)&month(joining date) created this column in database
201901
201902
201903
.
.
.
used below expression but not working
=Count(distinct{<yearmonth= {"<=$(vyearmonth )"}>} empno)
need urgent
it s beheaving strange
it 's not selected date
i need to design two filters one year and one Month
based on selection we need number of employess
it is not working <= when i concatenate two variables into third variable
if i use year alone it is working
any help
Hi dilip,
i use the expression you suggested but is giving data for selected year and month
<= is not working
I think you should use the below expression:
Count( {< year =, month =, yearmonth = {"<=$(=vYearMonth )"} >} distinct empno )
I hope it will fix your problem.
Than you it is working