topic Re: How to create unequal range to found count of tickets? in App Development

How to create unequal range to found count of tickets?

Rajamohan — Mon, 25 Apr 2016 03:32:16 GMT

Dear All,

I have a requirement to create an unequal range to found the count of tickets as follows:

In the attached excel, ticket sheets has the ticket no for the respective data. The no. of tickets should be shown in the range of the data as shown in the range sheet.

Please help how to achieve this? I tried with the interval match function which is not working.

Min_NetGrowthHeightPercentage	Max_GrossGwtHtPercentage	Range
0.01	29.99	0.01-29.99
30	54.99	30.00-54.99
55	59.99	55.00-59.99
60	64.99	60.00-64.99
65	74.99	65.00-74.99
75	99.99	75.00-99.99
100	125	100.00-125

For each range, I wish to find the count of tickets.

Pls. help.

Thanks.

Best Regards,

Raj.

Re: How to create unequal range to found count of tickets?

sunny_talwar — Mon, 25 Apr 2016 16:01:09 GMT

You can use a if statement to create unequal ranges

If(Field >= 0.01 and Field <= 29.99, Dual('0.01-29.99', 1),

If(Field >= 30 and Field <= 54.99, Dual('30.00-54.99', 2),

....

and so on...

Re: How to create unequal range to found count of tickets?

Rajamohan — Tue, 26 Apr 2016 02:14:14 GMT

Thank you so much Sunny for the quick response. I hope this solution will work.

- Mohan