cancel
Showing results for 
Search instead for 
Did you mean: 

pricing

Former Member
0 Kudos

Dear All,

My client requirement is

1. Price --- Rs 10000

2. C type 1 --- Rs 7.50

3. C type 2 --- Rs 1.50

4. C type 3 --- Rs 1

5. C type 4 --- 0.125% of steps 1+ 234 (i.e. 0.125% of 10010 = Rs 12.51)

6. C type 5 --- 0.0035% of step 1= Rs 0.35

7. Net value --- Rs 9977.14

For the calculation of step 5 the values of step 2,3,4 are added with step 1. In step 7, the values of step 2, 3, 4, 5, 6 are deducted from step 1. How to configure the same. Also while maintaining condition record for value 0.0035%, the system throws the error message 'Input must be in the format __,___,__~.___V'. For this problem, i suggested the solution as per the notes 38881. Client is not interested in that solution. Can any one please suggest me a solution.

Regards

Sankar

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Sankar

try this

1. Price --- Rs 10000

2. C type 1 --- Rs 7.50

3. C type 2 --- Rs 1.50

4. C type 3 --- Rs 1

5. C type 4 --- 0.125% of steps 1+ 234 (i.e. 0.125% of 10010 = Rs 12.51)

6. C type 5 --- 0.0035% of step 1= Rs 0.35

7.C type 6 from 1 to 1----10000--->positive condition type

8.C type 7 from 2 to 6 -


12.86------->negative type condition

9. Net value from 7 to 8--- Rs 9977.14

try and revert

Former Member
0 Kudos

Hi,

Thanks for your reply. If i maintain negative for the condition types in step 2 to 4, then while calculating the value for step 5, the system deducts the values of steps 2,3,4 from step 1. But i want to add the values of step 2, 3,4 with step 1. In step 7, i want to deduct the values of step 2,3,4 from step 1. How to achieve the same.

regards

Sankar

Former Member
0 Kudos

HI Sankar

You misinterpreted me.

1. Price --- Rs 10000

2. C type 1 - Rs 7.50--


>positive condition

3. C type 2 - Rs 1.50--


>positive condition

4. C type 3 - Rs 1--


>positive condition

5. C type 4 - 0.125% of steps 1+ 234 (i.e. 0.125% of 10010 = Rs 12.51)--


>positive condition

6. C type 5 - 0.0035% of step 1= Rs 0.35--


>positive condition

7.C type 6 from 1 to 1----10000--->positive condition type

8.C type 7 from 2 to 6 -


12.86------->negative type condition

9. Net value from 7 to 8--- Rs 9977.14

try and revert

Former Member
0 Kudos

Hi,

Try this.

10 Price

20 C type 1

30 C type 2

40 C type 3

50 Total 1 From 10 to 40

60 C type 4 from 50

70 C type 5 From 10

80 Total 2 From 20 to 40 (To sum Condition 1 to 3)

90 Total 3 From 60 to 70 (To sum Condition 4 to 5)

80 Total 4 From 80 to 90 (values of Conditoin 1 to 5)

90 Net Value From 80 with AItCBV to get Step 10.

Best regards,

Anupa

Former Member
0 Kudos

Hi,

Thanks. My question is, in one place the value is added (step 5)and in another place the value is deducted (step 7). In system either we can give the value as positive or negative. How to make the positive value as negative value.

Regards

Sankar

Edited by: sankar s on Oct 9, 2009 7:51 AM

Edited by: sankar s on Oct 9, 2009 7:51 AM