Newbie Questions

Re: Change in calculation based upon option button

kriz10gal — Wed, 05 Jul 2006 13:45:21 GMT

quote:
Originally posted by Matt Faus

Yes, you should be able to do this with a simple XSL statement. Assuming your schema looks like this:

Group
--LineItem (repeating)
----CreditCard
----Amount

Your calculated field will be this:
sum( LineItem/Amount[../CreditCard = "no"] )

To do this in the Designer,
1. double-click the field that you wish to calculate the total and click the Function button.
2. Click the Insert Function button, select sum, and then click OK
3. Double-click the link to insert a field, select Amount from the data source tree, and then click Filter Data
4. In the filter data, select CreditCard from the first drop-down, "is equal to", from the second drop-down, and then "no" from the third drop-down.
5. Click OK until you are back to the canvas, and then click Preview to try it out.

Nevermind! I originally had a problem, but I fixed it. My True/False values are 1 and 2, so the "no" didn't work for me.

Thanks so much!

P.S. How'd you get so good with InfoPath?

Re: Change in calculation based upon option button

Matt Faus — Sat, 01 Jul 2006 00:08:50 GMT

Yes, you should be able to do this with a simple XSL statement. Assuming your schema looks like this:

Group
--LineItem (repeating)
----CreditCard
----Amount

Your calculated field will be this:
sum( LineItem/Amount[../CreditCard = "no"] )

To do this in the Designer,
1. double-click the field that you wish to calculate the total and click the Function button.
2. Click the Insert Function button, select sum, and then click OK
3. Double-click the link to insert a field, select Amount from the data source tree, and then click Filter Data
4. In the filter data, select CreditCard from the first drop-down, "is equal to", from the second drop-down, and then "no" from the third drop-down.
5. Click OK until you are back to the canvas, and then click Preview to try it out.

Change in calculation based upon option button

kriz10gal — Fri, 30 Jun 2006 18:47:57 GMT

A choice on an expense report I am working on asks if the expense was charged to a credit card. If the expense was charged to the credit card, it isn't calculated into the weekly expense report, but simply written there for record. Currently, I have an "Expenses charged directly to Option Care Corporate?" choice in a repeating table with the other fields. It is a Yes or No (1 or 2) option. Is there a way for me to tell my "Total Expense" calculated field to NOT add the number if the option button "Yes" is chosen (but if otherwise, continue with the calculation)?