.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to calcuate percent change in Infopath

Posted By:      Posted Date: October 28, 2010    Points: 0   Category :SharePoint

Hi maybe someone out there can help me.  I need to calculate percent change in an InfoPath form services form. 

Using Excel, the formula would be: (NewSalary - OldSalary)/ABS(OldSalary).

Unfortunately, InfoPath 2007 does not seem to offer an ABS function.  I tried using an xpath expression with fn:abs(OldSalary) but no luck.

Thanks in advance for your help,


View Complete Post

More Related Resource Links

InfoPath toolbar button name change


How do I change the name of the buttons on the InfoPath toolbar? I want to change the names of the Save and Submit buttons to display something else.

Is it possible to change text orientation in InfoPath 2010?



I cant find how to change text orientation in InfoPath 2010. Who knows how to do it? I want my text has 90' orientation. There is no problem to do it in Excel. Is it possible to do in InfoPath2010? 

infopath change link tekst with getelementByTagName


i have  2 questions:


when you create a new document library, you have a link that points to the upload.aspx page.

i whant to change this link.

i can find the tag name, and also change the "link text name", link the following example

var ttnA = document.getElementsByTagName('A');
for (var j=0; j<ttnA.length; j++)
  if (ttnA[j].id == 'idHomePageNewItem')
      ttnA[j].innerHTML= 'Upload new document';

how do i change the link to a different page?


How can you hide the "new document" button in the ribbon?

with javascript code

are there 2 issiues possible, is yes how.


InfoPath -Validate a Field Based on ANY change in a Secondary Field


I would like to require a change to one field if a secondary dropdown field is changed at all.  At Minimum I would like to change the formatting or color of the field in question.


How to change the way the infopath form saves data in SharePoint library (Ex: Person/Groups field is

Person/Group field is taken as an integer field in SharePoint form library when a form is submitted. I need to retain it as Person/Group column in the SharePoint form library too. Please help on the same. Thanks.

how to change database connection of infopath datasource



my question is. i have created a form with a sql server database connection. now if i want to open these form on another machine, with the same database but another server name

how can i change the database connection for the datasource for this form?

thank you

Infopath browser view ignores change event handler

I have several radio buttons. On change, XmlChangedEventHandler  will perform some actions.  It works fine on InfoPath .  But it doesn't work on web browser.  After I click a radio button, nothing changes until I click on an irrrelevant button, all the changes all of a sudden show up.

how to change infopath form time (function now())

my infopath form has a default time now() for the field. my sp2010 server has correct time and time zone, for example 4:11pm EST now, but when open the form in sp2010 web browser form, it shows 1:11pm. any idea how to fix it?
however, if I do preview, it shows correct ime 4:11pm

InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

How to Localize Windows Forms and Change the Language at Runtime

Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Selected to change the background color of the page



As this site, http://www.borfin.com.tr/genel/Default.aspx, How can I change the background color selected pages.

Bug: Does not change column type from nvarchar to ntext


Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.

Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.

How to change the default page base class?


I've tried setting the <pages pageBaseType="DynamicWebPage" /> value in web.config, but when I response.write out the page type, I'm still getting Microsoft.WebPages.WebPage.

I'm simply trying to sub-class WebPage and add some additional functionality such as a dynamic PageData dictionary similar to Phil Haack's dynamic ViewData dictionary.



SqlDataSource how to change the stored procedures at run time



Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?



Change Button Text in Multi Language Website


Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this


How to change text in columns in SSRS?


I need to create a complex report and export it to Excel. 

In the first column header, text is displayed as "Hide Daily Columns", but I need the text to change as "Unhide Daily columns" when I click on it and when the text changes the columns under "daily" header (I have 3 columns under this header) present in the report shud be hidden and only weekly columns shud be visible. Any ideas please. I am new to SSRS and tried out many ways but didn't get it.

dynamically change column names in Crystal reports


I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend