Need a solution for a maths calculation [Resolved]

Posted by Thiru under Others on 3/21/2012 | Points: 10 | Views : 958 | Status : [Member] | Replies : 4
Hi Friends,
Can any one help to find a solutions here:

There are 3 fields named: GrossAmt, SerCharge and NetAmt

SerCharge = 5.1% on GrossAmt
NetAmt = GrossAmt - SerCharge

Example:
GrossAmt: 9,800.00
SerCharge: 499.80
NetAmt: 9,300.20


Now i have only NetAmt using this i need to find GrossAmt and SerCharge
How to find ?
Any suggestion please.
regards,
Thiru.




Responses

Posted by: Jmckamal on: 3/21/2012 [Member] Starter | Points: 50

Up
0
Down

Resolved
Hi.. I am Kamal.. It is possible to find Gross amount and Sercharge with the information you have provided.

Say..
X = Netamount (which you have already)
Y = Grossamount
z = Surcharge

X = Y - Z
(which is nothing but)
X = Y - 5.1/100 Y
X = Y - 0.051 * Y
X = 1 Y - 0.051Y
X = 0.949Y
X / 0.949 = Y (Gross amount)

Now as per your example,

9,300.20 / 0.949 = 9800

Hope now finding out Sercharge shouldn't be an issue for you by applying Grossamount and Netamount.. Enjoy..







Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hmanjarawala on: 3/21/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi Thiru,
tell me one thing that your sercharge % is fixed (5.1%) or it should be variant?

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Thiru on: 3/22/2012 [Member] Starter | Points: 25

Up
0
Down
Great Kamal.
Working perfect - Thanks a lot.

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Thiru on: 3/22/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Himanshu Manjarawala,
Its not fixed.
i stored it in database and fetching the same here for calculating.

regards,
Thiru.

Thiru, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response