Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Infopath Formula Filter

Posted on 2009-02-18
Medium Priority
Last Modified: 2012-05-06
Hello, I am trying to create a formula that filters data to not show up in the results.  Below is the code that is written but the option to add more than one filter does not seem to work.

sum(../dfs:dataFields/d:EmployeeInfo/d:VacationInfo/@Hours[../@Type_Vacation != "Vacation" or "Floating Holiday"])

Can someone suggest another option to try.
Question by:mrdesignit
  • 2

Expert Comment

ID: 23692312
I would put two seperate conditions in one rule. One for if it equals vacation and the other if it equals Flotating Holiday instead of having the or within your formula itself.

Author Comment

ID: 23819851
how would the code look on something like this.  Sorry for the delay the project went on hold and now I am back on it.

Accepted Solution

mrdesignit earned 0 total points
ID: 23867298
Figured it out, the problem was with the code = "Vacation" or "Floating Holiday".  The formula would not work unless the word translate was part of the formula.  Example....

sum(@hours[translate(../@Type_Vacation, "Vacation", "Floating Holidays")])

Not sure if that makes since, but it worked to return a sum of two different conditions.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question