Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i'm trying to filter some values on a filter pane with a expression like this:
if(
aggr(sum(FIELD1),FIELD2)>0,FIELD 3,
)
It works, but instead of selecting only the FIELD3 on the top active filter it select also FIELD2.
In another example:
if(aggr(sum(FIELD1),FIELD2)>0,FIELD 3 & ' ---- ' & FIELD4,
)
it will add also FIELD4 on the active selections...
how can avoid this? I want only to have on the top active selections the FIELD3
tnx
Hi,
I would suggest doing this logic in the back-end script to create a flag of sorts and put the new field in a listbox.
Regards,
Pravesh
hi,
if i create a new field like: FIELD 3 & ' ---- ' & FIELD4 as NewField
i get rid of FIELD4, but the problem is in the first scenario, i want to get rid of FIELD2 used in the AGGR function
Perhaps use an if statement outlining the same logic in the back-end script to create a new field which you can then reference in a list box. In that way, you keep the integrity of the original data as well.