Hi all, I have a record, but as i enter new ...

(Mohd Fadyllah) #1

Hi all,

I have a record, but as i enter new data(row) i want to knows the number of records in the table.How do i do this?

Second, from the total, how do i query to get a total base on one column criteria. E.g Category A,B and C.

Thanks

(Aleksi Alkio) #2

You can read amount of records with a formula COUNT(TableName[KeyColumnName])

COUNT(SELECT(TableName[KeyColumnName],IN([CATEGORY],{A,B,C})))

(Mohd Fadyllah) #3

Where i insert the formula? Thanks?

(Aleksi Alkio) #4

It depends what do you want to do with that value. Let’s assume you just want to show it. Create an additional Show type column and then add that formula into the “Content” field.

(Mohd Fadyllah) #5

Ok…Got it.Thanks

(Mohd Fadyllah) #6

Formula verity and work…but dont show anything on screen. BTW, i create a new table with a column set to show, and content using your formula.Thanks

(Aleksi Alkio) #7

What is your existing formula?

(Mohd Fadyllah) #8

COUNT(TableName[KeyColumnName]) just like you teach me but i replace the name with mine.Thanks

(Aleksi Alkio) #9

What is the app name, account ID, table name and column name? I can check the reason if it’s okay

(Mohd Fadyllah) #10

Hi, thanks…its works, it have to be in the datatable, creating a separate table for the “summary” shows nothing. Thanks BTW

(Aleksi Alkio) #11

You’re welcome