INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Groupcount syntax  (Read 2102 times)

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Groupcount syntax
« on: January 15, 2015, 04:38:27 pm »

Using an expression column I tried:
GroupCount([Bitrate]) - GroupSummary([Bitrate])

It doesn't work.
I inserted Bitrate using the Insert Field tool.

GroupCount(Bitrate) - GroupSummary(Bitrate)

It works as soon as one removes the [ and ]

Is this done on purpose?
I do think it a bit confusing if there are functions requiring [] and some that don't.
Logged

6233638

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 5353
Re: Groupcount syntax
« Reply #1 on: March 14, 2015, 03:27:43 am »

I agree, this is confusing. I thought fields were always supposed to be enclosed in square brackets?
 
I'm also seeing a huge reduction in performance when using GroupCount(Album) in a view with about 500 albums for example. Scrolling becomes very slow/unresponsive.
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42044
  • Shoes gone again!
Re: Groupcount syntax
« Reply #2 on: March 14, 2015, 07:51:50 am »

Is this done on purpose?

Yes.

That's how it works.

You want to put the field name and not the field value into the GroupCount(...) / GroupSummary(...) functions.
Logged
Matt Ashland, JRiver Media Center
Pages: [1]   Go Up