Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a listbox based on an expression like the following :
=if(aggr(sum(Amount),CustomerCode)<50, '<50', if(aggr(sum(Amount),CustomerCode)<500, '50-500', if(aggr(sum(Amount),CustomerCode)>500, '>500')))
The listbox is working but I have 2 problems :
1) I cant sort by the good order :
2) when I select a value from this listbox, the 2 non selected values disappear.
Do you know how to solve these issues pls ?
Regards
For
#2) add a set modifier to cancel out the CustomerCode selection:
=if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<50, '<50', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<500, '50-500', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)>500, '>500')))
1)
use dual
dual('<50',1) instead of <50
dual('50-500',2)
....
and sort by number
For
#2) add a set modifier to cancel out the CustomerCode selection:
=if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<50, '<50', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)<500, '50-500', if(aggr(sum( {$<CustomerCode=>} Amount),CustomerCode)>500, '>500')))
thank you, works fine