INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: robydago on April 12, 2007, 01:11:22 pm

Title: Can calculated data be... calculated?
Post by: robydago 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.

Title: Re: Can calculated data be... calculated?
Post by: gappie 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

Title: Re: Can calculated data be... calculated?
Post by: robydago on April 12, 2007, 06:19:21 pm

thanks gappie,
I'll wait 'till jriver add... 8) that feature to MC