INTERACT FORUM

Please login or register.

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

Author Topic: Can calculated data be... calculated?  (Read 1369 times)

robydago

  • Citizen of the Universe
  • *****
  • Posts: 518
Can calculated data be... calculated?
« on: April 12, 2007, 01:11:22 pm »

What I mean is: can I use math operations inside calculated data templates used by user library fields?

I'd like to create an AvarageRating field that will show the average between two different Rating fields (mine and my wife's)
All I need is very basic, something like:

Calculated data template: (Field(Rating1)+Field(Rating2))/2

But I'm not able to make it work.

Logged

gappie

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 4566
Re: Can calculated data be... calculated?
« Reply #1 on: April 12, 2007, 05:55:10 pm »

nope.
has been asked often. this is the last thread i remember http://yabb.jriver.com/interact/index.php?topic=39566.0

following from that thread you could make a calculated library field when you really want it with something like:

if(isequal([field(rating1)],5,2),if(isequal([field(rating2)],5,2),5,if(isequal([field(rating2)],4,2),4.5 etc etc


Logged

robydago

  • Citizen of the Universe
  • *****
  • Posts: 518
Re: Can calculated data be... calculated?
« Reply #2 on: April 12, 2007, 06:19:21 pm »

thanks gappie,
I'll wait 'till jriver add... 8) that feature to MC
Logged
Pages: [1]   Go Up