i wanna to use >= operator in if statement like if(salary >= '50000', employee >=) so it should show all employee name how earn then 50000 or more th

[Meshaikh1995]

i wanna to use >= operator in if statement like if(salary >= '50000', employee >=) so it should show all employee name how earn then 50000 or more then 50000

in my scenario i have to create an filter where if user put any date so its should show data of that date and more then equal to that date so i create an variable for date and put in filter and i don't know what should i wright to show data of selected date and more then equal to that date plz help me with this.

or just talk me this type of, if statement, if(salary >= '50000', employee >=) so it should show all employee name how earn then 50000 or more then 50000

[vikasmahajan]

Hi,

Can you please try :

sum(Aggr(If(Sum(Salary) >= 50000, Sum(Salary)), employee, DateField))

Thanks

Vikas

[Meshaikh1995]

no its not working as i want its showing other row's too, i want to create an filter pane  i.e. i have date from (01-01-2010) to (01-01-2022) so when if user write in filter pane 01-02-2012 so its should show data of 01-02-2012 to max of that field 01-01-2022