That worked great - thanks for your help!!
John
John
--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> ABSOLUTE( n )
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John
> Sent: Wednesday, May 26, 2010 12:32 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Progress question on calculated filed
>
> I'm trying to displace a Crystal report with a dashboard and have a formula like this:
>
> ((JobOper.ActProdHours) - (JobOper.EstProdHours)) /(JobOper.EstProdHours) * (100)
>
> I will have negative values from this and when I use crystal I use an "abs" in front of the formula to remedy this. Does anyone know of a way to get an absolute number using Progress syntax?
>
> Thanks!
>
> John
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>