https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/39832.aspxMon, 23 Mar 2009 06:01:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:39832Anuma0https://www.infopathdev.com:443/forums/thread/39832.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=39832<p>Hi,</p> <p>Can you add below formula to the third(% Difference)&nbsp;field.</p> <p><b>((Cost2/Cost1) - 1) * 100</b></p> <p><strong>And also verify below link for more details.</strong></p> <p><a href="http://www.nku.edu/~fordmw/%25difference.htm">http://www.nku.edu/~fordmw/%25difference.htm</a></p>https://www.infopathdev.com:443/forums/thread/39721.aspxThu, 19 Mar 2009 13:59:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:39721pablavo0https://www.infopathdev.com:443/forums/thread/39721.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=39721<p>HI folks,</p> <p>&nbsp;Hope someone can help.</p> <p>&nbsp;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.</p> <p>If at Cost1 was £25 and Cost2 was £30.&nbsp; Does anyone know how I would create a calculation to get the percentage difference?</p> <p>Thanks again</p>