Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Concat(Aggr(Max(ApprovalStatus) & ':' & Count(ApprovalStatus),ApprovalStatus),Chr(13))
Here is my example
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
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.