INTERACT FORUM

Please login or register.

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

Author Topic: Calculated Field Expressions  (Read 744 times)

EpF

  • Citizen of the Universe
  • *****
  • Posts: 649
Calculated Field Expressions
« on: January 08, 2006, 12:28:41 pm »

It's been a while since I looked at these, but I've been having a go at calculated field expressions, and hit my first pothole on my first attempt!

I wanted to make a Meta-Genre field, and tried this:

If([Genre]==[Acid House],[Alternative],...etc...,[Trip Hop],[Vibe]), Tech//Beat, If([Genre]==[Afrobeat],[Alt Folk],...etc...,[Reggae],[World]), World//Folk

But all I get is " , Tech/Beat, , World/Folk" all in one line.

I had been hoping to get a Meta-Genre pane with 'Tech/Beat' on one line and 'World/Folk' on another, with those strings of genres showing up in the next pane when filtered.

So, do I have to write If(isEqual([Genre], *genre*), Tech//Beat) for each genre (which really would not be worth it!), and if so, could we PLEASE have an 'or' function/modifier for the Expression Evaluator? ;D
Pages: [1]   Go Up