INTERACT FORUM

More => Old Versions => Media Center 13 (Development Ended) => Topic started by: ShayB on June 06, 2009, 01:47:40 am

Title: Q: how do I make an arithmetic expression?
Post by: ShayB 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?

Title: Re: Q: how do I make an arithmetic expression?
Post by: gappie 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

Title: Re: Q: how do I make an arithmetic expression?
Post by: ShayB 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)