Count of the Rows that match the another whole column

Like (0) Share

Report

Posted on 15 Jul 2021 05:32:00 by Haseebkhatri

Hi,

I've looking for the solution all over internet but failed, I have one sharepoint list that contains PhysicalBatchNo and SystemBatchNo with group ID's now i want the count that verify the values of physicalBatchNo with All the systembatchNo rows plus conditions that have same ID as well.

I have used

Filter(ChildList_3, PhysicalBatchNo in SystemBatchNo)

But it's looking only row by row not by group.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com on 15 Jul 2021 at 07:59:37

Like (0)

Report

Re: Count of the Rows that match the another whole column

Hi @Haseebkhatri,

I don't quite understand your needs.

I noticed that you have a ‘PhysicalBatchNo’ column.

But in the image there is a similar column called ‘SystemBatchNu...’

1.Are they the same column?

2.What's the data type of 'PhysicalBatchNo' column, 'SystemBatchNo' column and 'ChildID' column?

3.Are the three columns in the same list? ('PhysicalBatchNo' column,'SystemBatchNo' column and 'ChildID' column )

4.What are your specific needs? Could you explain your needs with some images?

Was this reply helpful? Yes No
Haseebkhatri 2 on 15 Jul 2021 at 08:18:39

Like (0)

Report

Re: Count of the Rows that match the another whole column

@v-qiaqi-msft
I want total count of rows of physicalBatchNumber that doesn't matches in column SystemBatchNo

That should be like this

Like value 1 Check systembatchnumber.rows that their childId equal to physicalBatchNumber ChildId

PhysicalValue1 should match SystemValue1 then Systemvalue2 then SystemValue3 until the childId gets unequal then it should move to physicalvalue2 and keep iterating and give me count. I hope I give better idea still you are unable to understand let me know

Was this reply helpful? Yes No