INTERACT FORUM

Please login or register.

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

Author Topic: Q: how do I make an arithmetic expression?  (Read 1150 times)

ShayB

  • Junior Woodchuck
  • **
  • Posts: 97
Q: how do I make an arithmetic expression?
« on: June 06, 2009, 01:47:40 am »

hi.

I would like to know which audio files have small replay-gain meaning:  "abs([replay gain]) < 1 DB"

how do I write the correct expression?
Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Q: how do I make an arithmetic expression?
« Reply #1 on: June 06, 2009, 04:59:10 am »

you could use this in a collumn:
if(isequal([Replay Gain],-7,3),Low,High)
less than -7 is low otherwise high...

 :)
gab

edit: when you want to use that in a smartlist paste this in the screen you get under import export:
[Media Type]=[Audio] [=isequal([Replay Gain],-7,3)]=1
Logged

ShayB

  • Junior Woodchuck
  • **
  • Posts: 97
Re: Q: how do I make an arithmetic expression?
« Reply #2 on: June 06, 2009, 09:36:34 am »

thanks,

I would like to share the expression that I needed. I use it to know if my audio files are volume-leveled or not:

I generated a calculated field and wrote the formula:

if(IsEmpty([Replay Gain]),Empty Value,  if(isequal([Replay Gain],-0.9,3), Too Low,  if(isequal([Replay Gain],0.9,5),Too High, Good ) )   )

which then gives 4 possible indications:
Empty value (in case the replay gain value is empty)
Too Low       (in case the replay gain has a value >  0.9)
Too high       (in case the replay gain has a value < -0.9)
Good            (otherwise)

Logged
Pages: [1]   Go Up