INTERACT FORUM

Please login or register.

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

Author Topic: Need help with building a calculated field  (Read 793 times)

DanielBMe

  • World Citizen
  • ***
  • Posts: 184
Need help with building a calculated field
« on: December 08, 2012, 01:01:25 pm »

I would like a title in Theaterview in the movie details screen to indicate if the movie is "DVD" or "Blu Ray".  Right now I see "IFO" or "BDMV".  How do I create a new field called Video that uses an expression along the lines of
If File Type = "BDMV" then "Blu Ray" else "DVD"

Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Need help with building a calculated field
« Reply #1 on: December 08, 2012, 01:06:23 pm »

The expression :

ifelse(
  isequal([Media Type], Audio), CD,
  isequal([File Type], bdmv), Bluray,
  isequal([File Type], ifo), DVD,
  1, other
)

will give you CD, Blueray, DVD, or other.  Strip out the lines you don't care about.

This can be placed either directly in Theater View as an expression category, or you could create your own field and reference that.
Logged
The opinions I express represent my own folly.
Pages: [1]   Go Up