Another Calculation problem - InfoPath Dev
in

InfoPath Dev

Another Calculation problem

Last post 03-22-2009 11:01 PM by Anuma. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 03-19-2009 06:59 AM

    Another Calculation problem

    Reply Contact

    HI folks,

     Hope someone can help.

     I have two fields with different amounts and I want to calculate the different variance in percentage. Or, another way to put it- the percentage difference between the two.

    If at Cost1 was £25 and Cost2 was £30.  Does anyone know how I would create a calculation to get the percentage difference?

    Thanks again

    ____________________________________

    Take a deep breath phsssssssssss

  • 03-22-2009 11:01 PM In reply to

    • Anuma
    • Top 25 Contributor
      Female
    • Joined on 07-20-2005
    • India
    • Posts 525

    Re: Another Calculation problem

    Mark as Answer
    Reply Contact

    Hi,

    Can you add below formula to the third(% Difference) field.

    ((Cost2/Cost1) - 1) * 100

    And also verify below link for more details.

    http://www.nku.edu/~fordmw/%25difference.htm

    Anuma Chinthapalli /
    http://www.GGKTech.com
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.