Formulas in Custom Property Do Not Show Results in Report

[Bryan]

Hi I have a custom property whose value is calcuated as follows:

=CY((Prop.RatePerHour*Prop.Duration)*Prop.Objects,"USD")

In the Custom Properties window the values update right away but when I run
a report the column for that value (Prop.Cost) which has the above formula
embedded in the Shape Sheet shows up as $0.00.

How can I fix this?

I'm using Visio 2003 with SP3.

Bryan

 

[JuneTheSecond \)cotton.ocn.ne.jp>]

Hi Bryan,

The resultant shape is embeded Excel sheets.
It might be that the function CY cannot be
translated into the function in Excel.
You might need not to use any special functions.

--
Best Regards.

JuneTheSecond
Now the Visual calculation is more visual.
http://www.geocities.jp/visualcalculation/english/index.html

 

[Bryan]

JunetheSecond,

That worked perfectly, now I just need to figure out how to put the report
on another page and have it updateable.

Thanks again.
Bryan

 

[Scott Helmers]

If you choose a report format of "Visio Shape", the report output will be
dropped onto the Visio page. If you then right-click on the report object,
you'll find mutliple choices, including:
Update report...
and
Run Report

The first one starts the report wizard to let you change report parameters.
The second one is probably the one you want -- it reruns the existing report
specification and updates the report shape on the page.