Wrong row number count

[debajyoti]

Shalin has a total of 14 orders. but the count for the row number is wrong. inside "shalin" the row number count is right. all other counts for the row number are absolutely correct only there the name "shalin" is the wrong count.

[WillowMobileSys]

In the the first image, when you tap the "Shalin 2" grouped row, how many rows do you see underneath it?

[debajyoti]

As you can see in the second image there are a total of 14 rows grouped by canceled, in process, and completed underneath "Shalin 2"

[WillowMobileSys]

Ahh, ok.  It is multi-level grouping and the second image is after tapping on the "Shalin" grouped row. Got it!  I thought you were showing two different views originally.

Are you using COUNT or SUM as the aggregate value for the Groupings?  If you are using COUNT then this is a bug and needs to be opened to AppSheet support.  If you are using SUM then switch it to COUNT.

[debajyoti]

I am using COUNT. All other row counts of the names are right only the name "Shalin" has this wrong count.

[WillowMobileSys]

I would report to AppSheet.   In the meantime, two things to try:

1)  There is a difference in Sorting and Grouping.   Grouping implies a certain sort order and maybe the differences are causing confusion.  Apply sorting as:

• Sales Person Name
• Status
• Date

2) If above doesn't work then un-group the view and only apply a Sort and check that you see 14 rows for Shalin then.

[WillowMobileSys]

@debajyoti   Did you try #1 above?

[debajyoti]

yes. but no result. thanks.

[debajyoti]

I did not receive any solution yet from AppSheet support. If anyone can fix this please reply. Thanks.

[gregdiana1]

It appears SHALIN is only counting IN PROCESS and CANCELLED (1+1=2) and omitting  COMPLETE but without more detail, from the others, it is not possible to tell.

Check that COMPLETE is spelled correctly is of the correct type and does not contain a ' which happens sometimes, It suggests something silly is happening and COMPLETE status is somehow not being recognized for that user.

Check in your spreadsheet cell for anything odd.

[Steve]

Confirm that all of the SHALIN rows have unique key column values. Each row must have a key column value that no other row has.

[debajyoti]

I have checked there were three different types of the name written by users like

1. SHALIN
2. Shalin
3. shalin

maybe this is the reason for the wrong counting. and I have replaced all in the same format and now the counting is absolutely correct. Thanks, everyone for helping me out of this.

[gregdiana1]

Cool 😀it is normally something silly 🙄 and If it is text input and not an enum then try to force all uppercase or lowercase. 👍