Distinct cout using Business Views

[jolak]

Hello Experts,
I am writing a business view and would like to write an array that counts a one to many relationship by group. I.e., I have many apples attached to one orange. I would like to count, by orange, how many apples I have. Can I do this via a formula in the business view?

 

[rb2005]

Do you decalre apples as array? You can create a formula using array in Business View but make sure you have already declared an array of apples or any column which you want to count and then group by oranges.