Switch case to check range of number

Help
1

Hi, I would like to use the switch case to check a number between two range inside each case.
Check the below image, I am getting error. Not able to do this. Please share your suggestons.
Capture

1 Like
2

Fine we can check like this
In expression be like
Convert.ToDouble(in_amount) > 78 And Convert.ToDouble(in_amount) < 4557

And in case mention as True and another case with value as False

Cheers @sarathi125

2 Likes
3

@sarathi125

As the error is mentioning Case value should be a double.

It depends on your requirements, but give a try to implement a mapping logic to assig a number to certain class/segment/category (name it as you feel ok) and then use this segment value in the switch activity

4

hey @sarathi125

You can check like this

Convert.ToDouble(in_amount) >= 78 And Convert.ToDouble(in_amount) <= 4557

And in case mention as True and another case with value as False

or if you are having more ranges then you can opt for nested if else.

Regards…!!
Aksh

1 Like
5

I need to check that amount range from 1-5000,
5000-10000, 10000>. Three cases should be used. Not only two.

1 Like
6

Hey Yes so it is not much cases so you can easily use if Activity here.

Regards…!!
Aksh

7

Yeah, then I have to use three if statements. If we have this switch similar to VB.nwt select then only one switch actually. Will check

1 Like
8

Yah we can use this expression in switch expression as input
IF (Convert.ToDouble(in_amount) > 1, “Greater than 1
IF(Convert.ToDouble(in_amount) < 5000, “Lesser than 5000”,
IF(Convert.ToDouble(in_amount) > 5000, “Greater than 5000”,
IF(Convert.ToDouble(in_amount) < 10000,”Lesser than 10000”,
IF(Convert.ToDouble(in_amount) > 10000,”Greater than 10000”,
“Less than 1”)))))

And mention the string mentioned above in the cases as value like Greater than 1 for case1, Lesser than 500 for case2… it goes on

Hope this would help you
Cheers @sarathi125

2 Likes
9

@sarathi125
Have a look on Integer Division

Int Division Operator:
amount 1 - 5000 Int Division 5000 = 0
amount 5000 - 10000 Int Division 5000 = 1
…
amount greater then 10000 Int Division 5000 is default case in the switch

10

Hi @sarathi125

Buddy check it out this attachment :slight_smile: :wink:

SelectSwitchVb.xaml (4.2 KB)

Cheers :slight_smile:

Regards…!!
Aksh

3 Likes
11

By far the best answer in this thread.

12

With this case can you output the result in arguments too? And use a varibale threshold? I’m imagining with input as double:

Select Case inAmount
Case 0 To lowThreshold
out=“low”
Case lowThreshold To highThreshold
out=“mid”
Case >highThreshold
out=“high”
End Select

Would this work?

13

The “Case value” can be only a constant value.
Not range, not variable.
This is the limitation of the activity :frowning:

Cheers

2 Likes
14

Hey @SoqedHozi

Off course it will :slight_smile:

It is possible just in case when you do not want to consider Optimization as a factor :slight_smile:

For your understanding find below sample as per your need :slight_smile:
SelectSwitchVb-With Variable Argument Cases -Aksh1yadav.xaml (4.5 KB)

image
image1053×509 24.8 KB

Regards…!!
Aksh

15

@sarathi125 are you able to resolve this? can you update the solution

16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.