INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: EpF on January 08, 2006, 12:28:41 pm

Title: Calculated Field Expressions
Post by: EpF 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