How to format numbers in the Pivot table of Portfolio Analyszer

[Newbie]

Hello Experts,
I tried to format the Actual Work value with a space for the thousands and a
"h" for "hours" with the following formula:



Format(Round(Sum(PeriodsToDate([Time].[Tout]),[Measures].[Actual
Work]),0),"# ###h")



It works fine in the pivot table, but the numbers are no longer numbers:
they are converted in strings, and the graph doesn't display anything for
this series of values. How can I keep that as numeric values?

Newbie

 

[Denis in Brisbane]

Newbie,

I guess you must be creating a calculated field based on Actual Work and
then going in to Commands and Options to set up the formula. You can
directly set the format for the Actual Work by selecting the format tab in
Commands and Options for the Actual Value field and use a mask like #
##0.0"h" as the number format.

You'll also need to set the format for the axis values in the chart.

I hope this helps.

Denis

 

[Newbie]

Thanks a lot Denis!
I think I have to buy some more powerfull glasses ;-(
Newbie

Newbie,

I guess you must be creating a calculated field based on Actual Work and
then going in to Commands and Options to set up the formula. You can
directly set the format for the Actual Work by selecting the format tab in
Commands and Options for the Actual Value field and use a mask like #
##0.0"h" as the number format.

You'll also need to set the format for the axis values in the chart.

I hope this helps.

Denis

Hello Experts,
I tried to format the Actual Work value with a space for the thousands and a
"h" for "hours" with the following formula:



Format(Round(Sum(PeriodsToDate([Time].[Tout]),[Measures].[Actual
Work]),0),"# ###h")



It works fine in the pivot table, but the numbers are no longer numbers:
they are converted in strings, and the graph doesn't display anything for
this series of values. How can I keep that as numeric values?

Newbie