Hi all,
I am a newbie to this forum and also InfoPath (I started using it around 3 days ago) and have became stuck on some calculations.
I have created two textboxes with number formats, which house two seperate values. These being Costs and Benefits, and then i would like to work out a calculation in percentage as a Return on Investment. For example, if i had 10,000 Costs and 10,000 Estimates i would hope that the calculation would show 0 as a Return on Investment. However with my coding abilities, i am returning a value of 100!!
My code within the textbox that is producing the 100 value is as follows: "TotalEstimatedCosts / TotalBenefitsValue * 100". It also doesnt make any difference on the number, as it keeps on producing incorrect values. For example another is: 5000 Benefit divided by 10000 costs is producing 200! (A positive value too).
Could anyone be kind enough to tell me where i am going wrong?
Thanks,
Scott.