Problem with Portfolio Analyzer Calculated Field

[Haris]

Hi,
I'm trying to use the following formula in porftolio analyzer calculated
total option but get an error given below

IIf([Resource List].[Resource Name]="ABC",[Measures].[Actual Work]*100,
<Nested IIF> )

ERROR:

The query could not be processed
- Formula Error - Token is not valid:
"IIf([Resource List].[Resource Name]="ABC"^,^ [Measures].[Actual Work]*100,
<Nested IIF> )

What am I doing wrong ? Kindly advise.

Regards,
Haris

 

[Ray McCoppin]

IIF is not supported here. This is MDX query language syntax I think.

 

[Jacek Segit]

Hi,
I'm trying to use the following formula in porftolio analyzer calculated
total option but get an error given below

IIf([Resource List].[Resource Name]="ABC",[Measures].[Actual Work]*100,
<Nested IIF> )

ERROR:

The query could not be processed
- Formula Error - Token is not valid:
"IIf([Resource List].[Resource Name]="ABC"^,^ [Measures].[Actual Work]*100,
<Nested IIF> )

What am I doing wrong ? Kindly advise.

Regards,
Haris

Create Calculated Member in Analysys Manager directly, not via Project
Web Access.

Regards,
Jacek Segit

 

[Haris]

Jacek:

Thanks for the reply. Kidnly elaborate as to how can I create calculated
member in Analysis manager. Your help in this regard would be greatly
appreciated.

Regards,
Haris

Hi,
I'm trying to use the following formula in porftolio analyzer calculated
total option but get an error given below

IIf([Resource List].[Resource Name]="ABC",[Measures].[Actual Work]*100,
<Nested IIF> )

ERROR:

The query could not be processed
- Formula Error - Token is not valid:
"IIf([Resource List].[Resource Name]="ABC"^,^ [Measures].[Actual Work]*100,
<Nested IIF> )

What am I doing wrong ? Kindly advise.

Regards,
Haris

Create Calculated Member in Analysys Manager directly, not via Project
Web Access.

Regards,
Jacek Segit

 

[Jerry]

Dear Haris

The link to article belwo will help you understand and create
Calculated members step by step.
http://www.databasejournal.com/features/mssql/article.php/3106671

Hope this helps
Regards
Jerry