on 10-09-2009 5:51 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.