Count

[gautik92]

I have a table wiith column name Approval status as

0.created

1,approved

2.cancelled

how can i count the individual 0,1,2

[anbu1984]

Concat(Aggr(Max(ApprovalStatus) & ':' & Count(ApprovalStatus),ApprovalStatus),Chr(13))

[alexandros17]

Here is my example

[sujeetsingh]

Just tale the number as Subfield(Status,',',1) or subfield(Status,'.',1) this will only return the integer part of the string and hence you can add them

[jagan]

Hi,

If you got the answer please Close this thread by giving correct and helpful answers to the posts which helps you in getting the answers.  So that it helps others to find answers easier.

Regards,

Jagan.