英文:
Count how many instances the value in a column appears in that column
问题
| ptnum | virtual_column |
|---|---|
| 123 | 3 |
| 123 | 3 |
| 222 | 1 |
| 123 | 3 |
英文:
I need to create a virtual column in APPSHEET that will return a count of how many times the value in [ptnum] appears in the data table column [ptnum]. I want it to return the number as value in the virtual column. I need an APP Formula
example
| ptnum | virtual_column |
|---|---|
| 123 | 3 |
| 123 | 3 |
| 222 | 1 |
| 123 | 3 |
答案1
得分: 1
这个公式计算所有与此行的 ptnum 相等的条目数：
SELECT(
TABLE[ptnum],
[ptnum] = [_THISROW].[ptnum]
)
)```
<details>
<summary>英文:</summary>
This formula counts all entries where **ptnum** is equal to this rows **ptnum**:
COUNT(
SELECT(
TABLE[ptnum],
[ptnum] = [_THISROW].[ptnum]
)
)
</details>
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论