Basic Beginners Help Please! How do you use info in column count as a table field?
I am on a trial version of Ninox after using MS Access for years. I am trying to figure out how to find the percentage of the count of 2 columns on a table.
My columns are 'Order Ref' and 'Quote Ref', both text fields. I have the total count at the bottom of the columns on table view. I want to use this data to find out the percentage of sales we acquired. e.g. count of 'Quote Ref' is 20 and count of 'Order Ref' is 10 so percentage is 50%.
Any help would be appreciated.
3 replies
-
Hi Paula -
Sadly you can use the numbers you see at the bottom of columns in Table view.
You have to create new formula fields. One would count Quote Ref and another would count Order Ref. Then a third would then take the two count formulas and give you the percentage.
Before we can count records we need to know how you want to filter your table to get the proper count.
-
Thanks so much for your reply. I have managed to get it to work from another table but I want to do a count from data on the same table - what would be the formula for this?
-
I'm guessing you are using the select statement. If so then you would take the select statement and put in the name of the table you are in.
Content aside
- 2 yrs agoLast active
- 3Replies
- 55Views
-
2
Following