Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[StFeder]

For over an hour I'm trying to make a simple math expression work. I don't get it.

Goal
I'm trying to compare two values. I want to use the result of this comparison in a more complex expression to decide which value should be displayed.
Finally I'll use something like this:
   IfElse( IsRange( Math( [BPM manual] - replace([BPM calculated], /,, .) ) , 1-3 ), [BPM calculated], IsEmpty( [BPM manual] ), *[BPM calculated], 1, [BPM manual])

Current state

   Math(replace([BPM calculated], /,, .) - [BPM manual])

So, what I am trying to do is a simple subtraction. I used the wiki to figure out how to handle the replace expression to replace the local "," as decimal separator with "." to make the math expression work. It contains two user fields.

BPM calculated
It's an expression field which divides JRiver analyzed bpm value with 4. It looks like this:
   Math([BPM (analyzed)] / 4)

BPM manual
This is an user data integer field which only contains numbers with zero decimal places.

Current output with current state
15 - 15 = -45
33,25 - 16 = -99,75
15,25 - 16 = -45,75
33 - 16 = -99
42 - 22 = -126


Can anybody figure out what am I doing wrong?

[MrC]

What is [BPM (analyzed)]?

[StFeder]

It's the field which contains the result of MCs audio analyses which I renamed.

[StFeder]

OK, your question guided me to the solution. I was using a wrong field name at some place. Now it works.

[MrC]

And what type is BPM calculated defined as?

Ok, never mind.  Good.

[StFeder]

Looks as if I'm unable to use the "InRange" Expression  

This part of the expression now works correctly:
  Math(replace([BPM calculated], /,, .) - [bpm StFeder])

But I don't get a value "1" for my "InRange" expression even if the result of the above expression is in the defined range...
  IsRange(Math(replace([BPM calculated], /,, .) - [bpm StFeder]), 0-3)

Investigating

[MrC]

The result of your Math() could also be a floating point, and as such, you'll have to do a Replace() on the result so any comma gets translated to period.

[StFeder]

I was thinking about this to. Now I ended up with this one:

IfElse( IsRange( Math( abs( replace( [BPM calculated], /,, .) - [bpm StFeder])), 0-3), [BPM calculated], IsEmpty( [BPM StFeder] ), *[BPM calculated], 1, [BPM StFeder])

I had to eliminate the negative values using the math function abs( and then it worked. Looks as if the InRange expression does work with comma. Now the complete expression is finally doing its job

Thanks, MrC, for taking the time! Sometimes the right questions gives the solution. And you had the right one 

[MrC]

Sure, no problem.

Because of the way the MC expression language parses and evaluates, no functions can "know" the difference between the comma used to separate the arguments, and a comma output as the result of field interpolation.

So, keep in mind the following:

    functionA( functionB( functionC() ) )

always evaluates FunctionC first, and then MC looks for the arguments to the FunctionB call.  And so on, to FunctionA.