SharePoint Integration

Re: Calculated Column Tabulating Data from Two Separate Columns

Hilary Stoupa — Tue, 25 Apr 2017 22:41:24 GMT

Can you attach a screenshot showing the list & data?

Re: Calculated Column Tabulating Data from Two Separate Columns

Curtis — Tue, 25 Apr 2017 15:17:27 GMT

The column only gave me '0' when I choose a park that has 14 systems with 8 compliant (the totals are manually counted and configured by me in the list.

If doing what I'd like it to do, the column you worked on would also read 8, in this case.

What I am trying to do is get the column you worked on to automatically provide the total of compliant inspections for the park chosen in the Park field at the top.

Re: Calculated Column Tabulating Data from Two Separate Columns

Hilary Stoupa — Tue, 18 Apr 2017 14:30:23 GMT

Well, I still am not sure I have a good grip on what you want, but I did add a total column to your repeating table with a filtered count expression that will hopefully get you pointed in the right direction. Save the attached form locally. Right click and select Design to open in design mode. From there you can take a look at the expression, or try it in preview. I did run into the usual IP browser form bug where it thinks an expression that performs a function on a repeating node might return more than one item, so had to modify the view file manually as per this blog post: http://www.infopathdev.com/blogs/hilary/archive/2012/01/19/ipfs-design-checker-errors-amp-print-preview.aspx

Re: Calculated Column Tabulating Data from Two Separate Columns

Curtis — Mon, 17 Apr 2017 17:45:03 GMT

PWR Annual Fire and Life Safety System ITM Compliance List.

Re: Calculated Column Tabulating Data from Two Separate Columns

Hilary Stoupa — Mon, 17 Apr 2017 14:34:35 GMT

What is the name of the data connection with the "status" column?

Re: Calculated Column Tabulating Data from Two Separate Columns

Curtis — Fri, 14 Apr 2017 16:04:53 GMT

Here is the form where the data is displayed. There is a repeating table, center page, with 'No of Systems' and 'Systems Inspected'. The information comes from one of two lists; 'Park-wide Compliance', on which I manually add the totals after updating the 'Park A-123 Compliance List', which has 'Park Name' column (there are potentially 61 parks, and each park can appear several times on the list), a 'Compliance' column. The is also a 'Status' column that will have a corresponding 'Compliant' or 'Noncompliant'. I am trying to total the number of times each park appears in the 'Park Name' column that also appear as 'Compliant' in the Status column.

Re: Calculated Column Tabulating Data from Two Separate Columns

Hilary Stoupa — Fri, 14 Apr 2017 14:23:39 GMT

InfoPath doesn't support COUNTIF. You can use count - you just end up having to add a filter to the row. The filter depends on a number of factors, but it sounds like you are trying to create totals for each park? You can attach your form under the options tab & I'll give you a hand.

Calculated Column Tabulating Data from Two Separate Columns

Curtis — Wed, 05 Apr 2017 20:59:26 GMT

I have a 'Park' column and a 'Status' column on the same list. I'd like to created a calculated column called 'Total'. This column would use a formula to read the 'Park' column to determine the number of times a specific park appears AND also is shown as "compliant" in the 'Status' column. I've tried several COUNT and COUNTIF iterations, with no luck. Is this doable?