InfoPath 2010

Re: Need help in adding excel formula into Infopath

donstephen — Tue, 04 Feb 2014 03:48:24 GMT

Hi venkatkbv,

Here is a link for basic formulas which can help you get started. For the IF related calculations, you can make use of conditional rules which you will find on the Rules task pane if you click on the Manage Rules button under the Home tab. So instead of using a default value calculation, you can add an action rule that will set a field to a desired value, if a condition has been met.

Also, since you are dealing with tables and the sum of total values, you can make use of the formula sum(RepeatingField), where RepeatingField is the field of the repeating table. Hope this helps.

Need help in adding excel formula into Infopath

venkatkbv — Mon, 03 Feb 2014 21:30:27 GMT

Hi,

I am new to Infopath and currently just learning via experimentation. Recently i have been asked to move an excel spreadsheet to an infopath form .

I have no coding experience. I have managed to get the form a shape with the text and the drop-downs. However, i am totally stuck in the calculations of the fields, that involve Taking the sum of certain fields and displaying them in percentages.

Also there are a few IF related calculations in a few fields.

Importing the Excel sheet didnt fetch the formula on the form. Kindly suggest any Documents or Tutorials that could help me in adding excel calculations into the form.