Newbie Questions

Re: insert formula accumulative sum

Hilary Stoupa — Thu, 10 Sep 2009 22:30:16 GMT

I vaguely remember that IP2003 had some .... oddities .... when trying to use the current() function in a default, which the sample I posted relies on. I'm not too sure of a good work around for that. If you know in advance how many choices your users would have, and what the values would be, you could simply use sums with filters -- like sum(dollarValueNode[../itemNode = 'ItemA']), but it loses its dynamic qualities.

Re: insert formula accumulative sum

Roxanne — Wed, 09 Sep 2009 14:48:44 GMT

The items are only showing up once in the summary but it isn't totaling for me. Any suggestions?

Re: insert formula accumulative sum

Hilary Stoupa — Tue, 08 Sep 2009 21:23:46 GMT

I've attached a copy saved as IP 2003 format. Let me know if gives you any trouble.

Re: insert formula accumulative sum

Roxanne — Tue, 08 Sep 2009 20:27:35 GMT

Do you have an sample of this for InfoPath 2003?

Re: insert formula accumulative sum

idali — Thu, 18 Jun 2009 23:26:30 GMT

hi Hilary

yes, i use the sample and now it works,

my last question was only to know what is the difference between the tow xpath getting from the same formula

thank you very much

Re: insert formula accumulative sum

Hilary Stoupa — Thu, 18 Jun 2009 22:34:02 GMT

I'm sorry, I'm a little confused -- do you have this resolved for your form?

Re: insert formula accumulative sum

idali — Thu, 18 Jun 2009 19:51:43 GMT

Hi Hilary,

thanks for your advices thats works all the time.

i have a question about formula and xpath :after editing the formulat : @name[@id = current()/Client]

the xpath is:

xdXDocument:GetDOM("clientnames")/clients/client/@name[xdXDocument:GetDOM("clientnames")/clients/client/@id = current()/my:Client]

and the expressionBox display the first items whatever the choice from the dropdownbox

once i change a part by ".." and the xpath became:

xdXDocument:GetDOM("clientnames")/clients/client/@name[../@id = current()/my:Client]

the expression box display exactly the item chosen in the dropdownbox.

Re: insert formula accumulative sum

Hilary Stoupa — Thu, 18 Jun 2009 18:02:54 GMT

Saw your other post, please see the sample attached to this post.

Right-click on the link in the header and select save as to save locally. Right click on the saved file and select Design to open in design mode, then preveiw.

Re: insert formula accumulative sum

Hilary Stoupa — Thu, 18 Jun 2009 17:48:16 GMT

This depends on where your drop down gets the list of values / display names. If they are manually entered into the list, we need to do some conditional values for our expression box. If they come from a secondary data source, it is a bit easier -- where do your drop downs get their list from? I'll post a modified sample for you....

Re: insert formula accumulative sum

idali — Thu, 18 Jun 2009 16:52:08 GMT

Hi Hilary,

In the Sample ,@name is used tow times in drop down box proprieties : for the value and name

value---->@name

..name--->@name

in this case the expression box shows the name,

but if i use a Id for the Value (value---->@id) the expression box shows the Id instead of Name

how can i convert do Id to show the name instead

thanks

Re: insert formula accumulative sum

idali — Wed, 17 Jun 2009 14:08:49 GMT

Hi Hilary,

thank you very much it's exactly what i was looking for , i'm trying right now to adapte it to my Form (using additional fields that have default values that are filtered)

thanks

Re: insert formula accumulative sum

Hilary Stoupa — Wed, 17 Jun 2009 01:22:23 GMT

Hi:

When you say you only want to display the active project, can you tell me more about what you mean? You can use an expression box to create a conditional sum (unless this is a browser based form, in which case you'll have to add another field with a default value). Your formula for that expression would vary according to your data structure. There is a sample form here that may help you.

It uses additional fields that have default values that are filtered, but I think it will give you an idea or two...

insert formula accumulative sum

idali — Tue, 16 Jun 2009 20:32:02 GMT

Hello ,
I m new to InfoPath I used to get all answers looking here in this wealth forum.
I have a repeating table with a dropdown list to choose a project name
Date -----Project------time
------------------------- total time
One can fill out the form by picking a date, choosing a Project and adding time. The total time appear as sum of times
Date1 -----Project1------time1
Date2 -----Project2------time2
Date3 -----Project1------time2
------------------------- total time
What I want to do is to have automatically the accumulative time for each project that appear in the last repeating table
Project1 ----totaltime
Project2 ----totaltime
Project3 ----totaltime
The simplest way is to create a new table with all projects and make a conditional sum but I have a lot of project and I want to display only the active ones!
Any idea