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

[Mohd_Fadyllah]

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]

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

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

[Mohd_Fadyllah]

Where i insert the formula? Thanks?

[Aleksi_Alkio]

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]

Ok…Got it.Thanks

[Mohd_Fadyllah]

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]

What is your existing formula?

[Mohd_Fadyllah]

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

[Aleksi_Alkio]

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

[Mohd_Fadyllah]

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

[Aleksi_Alkio]

You’re welcome