INTERACT FORUM

Please login or register.

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

Author Topic: HELP: math log10 doesn't work with fields?  (Read 891 times)

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
HELP: math log10 doesn't work with fields?
« on: July 14, 2011, 11:49:26 am »

I'm trying to use a math expression with log10 calculations.

I want to turn the Peak Level into a dBFS value, which requires using log10 functions (20*log10(x) where x is the peak level)

I can convert [peak level] into a decimal value using =formatnumber([peak level,0],2), but the log10 function doesn't seem to work with expressions

So, for instance this, works:

=math(20*log10(0.5))

But this doesn't:

=math(20*log10(formatnumber([peak level,0],2))

I've tried breaking things down into calculated fields but that doesn't work either, eg

=math(20*log10([my field]))

Anybody have a solution?

Matt?!

Cheers,

Mark



Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: HELP: math log10 doesn't work with fields?
« Reply #1 on: July 14, 2011, 12:17:58 pm »

math(20*log10/(formatnumber([peak level,0],2)/))
Logged
The opinions I express represent my own folly.

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: HELP: math log10 doesn't work with fields?
« Reply #2 on: July 14, 2011, 03:37:53 pm »

Brilliant!  Many thanks.
Logged
Pages: [1]   Go Up