Show Noti Number

[Phyo]

Hello

I made the "Review" view in primary navigation with dashboard in tabbed format. Under that I have Various things like Form, Report and so in. Under Form, I made the card view for form like Trasport Requisition Form, Overtime Form in card format. By clicking them, I can go and see pending and approved request in data sheet view. In the forms, I have the column name Reviewer Status. It can be either Not started or Pending or Approved. I want to count the total number of pendind and show it beside or somewhere. For example. Transport form has 3 pending. It should show like Transport Form (3) in red color. Or 3 in somewhere in that card view is fine. If it doesn't have any pending it should show only name in black color. Same goes to the Form. It should count all the pending request of Form and show Noti with number if there is any.  I attach the image of the view below. 

Thanks in advanced for your help. I attach the image of the view belo

[Steve]

COUNT()

[Phyo]

Count cannot used directly to get my result. I even have sliced the pending request from datasheet and tried to count total number of row in there and it doesn't work.

[Steve]

Please post a screenshot of the configuration of this specific view:

[Phyo · Accepted solution]

I sliced the record table and count the row of sliced table. I use swithc to determine form type and Concat with Name to show the value beside it and it works back now. Thank you.

SWITCH(
[Code],
"TRF", IF(COUNT(Pending TRF[_RowNumber]) > 0,
CONCATENATE([Name], " (", COUNT(Pending TRF[_RowNumber]), ")"), [Name]),
"OVT", IF(COUNT(Pending OVT[_RowNumber]) > 0,
CONCATENATE([Name], " (", COUNT(Pending OVT[_RowNumber]), ")"), [Name]),
[Name]
)