Skip to main content

Rollups - counting the number of entries

  • September 1, 2022
  • 4 replies
  • 366 views

Sean_Lake1
Forum|alt.badge.img+20

Hey all,

I have a rollup field, separated by commas, yes, but what I need is a count of said field, so that I can have the actual number of items represented by said rollup.

A simple COUNT won’t work as the field is a rollup. I’ve tried formulas with arrays, etc. COUNTALL(ARRAYUNIQUE({Kaltura PlaylistIds - done})) for example, but to no avail. It’s weird, it was working one day, and now it just reports 1 for everything.

Thanks!

4 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Sean_Lake1 ,

you need to have another Rollup field and choose COUNTA(values)


Sean_Lake1
Forum|alt.badge.img+20
  • Author
  • Inspiring
  • September 2, 2022

Hi @Sean_Lake1 ,

you need to have another Rollup field and choose COUNTA(values)


only problem is, the field that needs counting is a rollup, so it’s not available for selection :frowning:


Sean_Lake1
Forum|alt.badge.img+20
  • Author
  • Inspiring
  • September 2, 2022

Hi @Sean_Lake1 ,

you need to have another Rollup field and choose COUNTA(values)



Mohamed_Swella1
Forum|alt.badge.img+17


Hi @Sean_Lake1 ,

I think I understand that. What I mean is duplicate this field and instead of ArrayJoin (or whatever Array function you are using) use the COUNTA function :slightly_smiling_face: