INTERACT FORUM

More => Old Versions => Media Center 14 (Development Ended) => Topic started by: badger on February 27, 2010, 12:00:13 pm

Title: Any way to round a custom integer or decimal field?
Post by: badger on February 27, 2010, 12:00:13 pm

I am importing DVD "length" (which is in seconds) from PVD into a custom field which i divide by 60 ([length]/60).  Is there any way to round the result to the integer... or something less than the 8 or 9 decimals it now reports?

Title: Re: Any way to round a custom integer or decimal field?
Post by: marko on February 27, 2010, 12:05:10 pm

try: formatnumber([Custom Field],0)

So, your custom library field contains the data, and you use the above expression in your views to display the data in the format specified.

-marko

Title: Re: Any way to round a custom integer or decimal field?
Post by: badger on February 27, 2010, 02:13:48 pm

Thank you.  I ended up with ........ formatnumber(math([Length]/60),0) for display.