Hello i am trying to write a formula to get the count of salesorders for a particular customer. There is a custom list field on SO it has 3 values so i need show the count of SO's for each type for the each customer. Formula is something like this case when {custfield} = 'somevalue' & {sointernalid} then count{sointernalid} this is not working. Any let me know how do i write it thanks.