Skip to Content
0
Dec 03, 2018 at 07:54 PM

Input control Checkbox sorting

96 Views

Hi Experts,

I am using Input Control as Check box along with the value as $10K+, $5K, $5K-$9K, >$9K and <$10K in the checkbox list as sequence now i wanted to re-arrange the sequence as below

$5k

$5K-$9K

>$9K and <$10K

$10K+

Formula variable created and using this in an input control:

=If([Actuals])<5000) Then "<$5K" ElseIf ([Actuals]) <= 9000 And [Actuals]) >= 5000) Then "$5K-$9K" ElseIf ([Actuals]) <10000 And [Actuals])>9000) Then ">$9K and <$10K" Else "$10K+"

Tried ascending, descending, custom sort doesnot work as expected to arrange to the sequence.

Appreacite your help on this.

Thanks,

Dinya