General

Re: Contains function + Sum function

lou131 — Thu, 29 Mar 2007 13:36:49 GMT

I will try it...thanks

Re: Contains function + Sum function

B.Shiva Prasad — Thu, 29 Mar 2007 08:13:57 GMT

Hi lou131,

Why dont you try for applying rules by inserting a button and setting a condion on that. If field1519 = "Targeted" or "Migrations" then set the functionality what ever you want in the field161.

Hope this will help you.

Re: Contains function + Sum function

lou131 — Wed, 28 Mar 2007 14:48:00 GMT

In addition, the field161 is the actual field doing the calcualations and where I'm trying to get this formaula to work. I have a deadline so any quick replies is appreciated.

Re: Contains function + Sum function

lou131 — Wed, 28 Mar 2007 14:29:46 GMT

Still having issues:

Repeating Table

I have a field that is a drop down list. The choices are Targeted and Migrations(Field1519). Based on this choice, I want to divide 2 other numberic fields (field160 and field158) and diplay it as a percentage.

Any additional help would be appreciated....

Thanks
Lou

Re: Contains function + Sum function

lou131 — Wed, 28 Mar 2007 13:49:45 GMT

So would it be something like this:

sum((field1519[.="targeted"]) field160) / sum((field1519[.="targeted"]) field158)

Re: Contains function + Sum function

Clay Fox — Wed, 28 Mar 2007 13:36:17 GMT

Ok what you would want to do is put the filter on the field you would want to sum. You know what you want to do you just need the correct method.

sum(products[.="good"]) / sum(products[.="bad"])

When creating you formula and selecting the fields select the Filter Data button in the bottom left of the window and then put in your criteria that would limit the fields returned.
Such as field = "Targeted"

Re: Contains function + Sum function

lou131 — Wed, 28 Mar 2007 13:21:08 GMT

Contains field name, "Targeted") ??? sum(field name) / sum (field name).

It seems that I can't link both functions together. The question marks above is where I'm having an issue. Basically, I'm trying to do an If then calculation. If a feild equals a certain text, then do a certain calculation.

Re: Contains function + Sum function

Clay Fox — Wed, 28 Mar 2007 13:12:26 GMT

Can you give us an example? What do you have so far and what are you trying to get?

Contains function + Sum function

lou131 — Wed, 28 Mar 2007 13:06:34 GMT

Hi,

I'm trying to tie a Contains function with a Sum function and can't seem to figure out the prefix between both functions to make it work.

Any suggestions....

Thanks
Lou