Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this filter:
This is my expression:
=if([Fatturato (k€)]<=50000, ' < 50 mln ', If(50000 <<[Fatturato (k€)]>= 100000 , ' 50 mln < & <100 mln', ' >100 mln'))
I want order:
' >100 mln'
' 50 mln < & <100 mln'
' < 50 mln '
TK
NM
Try this:
=If([Fatturato (k€)] <= 50000,
Dual(' < 50 mln ', 3),
If([Fatturato (k€)] > 50000 and [Fatturato (k€)] >= 100000,
Dual(' 50 mln < & <100 mln', 2),
Dual(' >100 mln', 3)))