Scale problem in maintaining condition records

[Former Member]

Dear All,

I want to maintain scales in inforecord.

But I have scale range of 1000 & want to maintain up 2000000.

means

0- 1000 100 Rs

1000- 2000 200 Rs

-

---

-

---

Up to 2000000

Tell me shortest way to maintain it.

Because If I use above method it will create more than thousand lines in scales.

Which I want to avoid.

Regards

Gitesh

[former_member183879 · Accepted solution]

Hi,

You are right that maintaining the records may be a difficult task here.

For this problem, you can create a Alternate Calculation value routine and you can put an algorithm there to calculate the price based on the number of units.

For example, here you have mentioned that 0-1000 units is Rs100. You can convert this into

Price = Number of units / 10. Like this you have to find out the algorithm and code that algorithm in the routine to enable the solution.

If you feel that the algorithms are different at different level, then you can maintain a Ztable for tabulating the level and the algorithm to be used and then depending on the number of units, you can call the respective algorithm in the routine.

Hope that helps

[Former Member]

Hi,

Maintain a 'Z' table with your scales, which you can easily maintain anytime.

write a routine with one select statement to fetch correct value from Z table.

for ex:

Ztable:

Scale_low..........scale_high............value

...0.........................1000.....................100

...1000..................2000......................200

Select "value" from Ztable where condition value > Scale_low and condition value < Scale_high.

try and revert.