Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to set an action on a text object in Select in Field for the field Client and Search String:
=if(aggr(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 and sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client)
Goal is to select all those Client values that fulfill above expression.
Thanks.
your 2 conditions should be separated by '+' symbol not the 'and' keyword so that it becomes a proper set analysis expression.
Hi,
Try this expression
='(' & Concat(aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 AND sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client), ',') & ')'
Regards,
Jagan
Ramkumar, I tried this but didn't work:
='('&Concat(Aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 + sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client),',')&')'
Jagan Mohan,
Tried your approach but didn't work:
='('&Concat(Aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 + sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client),',')&')'
Hi,
Dont use + sign the expression I given is not having +,
This will give comma separated values of Client satisfying the condition
=Concat(aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 AND sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client), ',')
If you want to use this in Select In Field trigger then you have to use | as separator and ( ).
='(' & Concat(aggr(if(sum({1<Week={'>=2'}, Flag={0}>} Sales) < 1000 AND sum({$<Flag={0}>} SalesWTD) >= 1000, Client), Client), '|') & ')'
This is working for me, if not working for you then attach a sample file.
Regards,
Jagan.