COUNT IF
hi,
i’m building an app for the invoices, and i need to count the issues invoices.
I’ve 2 column: ISSUED : YES/NOT INVOICE N° : where i must insert the formula
i checked https://help.appsheet.com/expressions/functions/count but i didn’t find the solution.
How can i do?
What have you tried?
COUNT(LIST and COUNT(SELECT
You can do that like COUNT(SELECT(TableName[KeyColumn],[ISSUED]=“Yes”))
Hello there, I am from Mauritius, Indian Ocean and have a similar issue. Can you please assist me with an issue? How can I count a field in a related table? That is I have an order table that I want to sum up the total units ordered in the order sum table. Related with the OrderID field. Thx
Tx Aleksi for your support, i tried also COUNT(SELECT(TableName[KeyColumn], IN([ISSUED], {“Yes”}) and it also works
Try something like SUM([RelatedOrderDetails][Units]).
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |