Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you please try :
sum(Aggr(If(Sum(Salary) >= 50000, Sum(Salary)), employee, DateField))
Thanks
Vikas
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