Calculated Total Calculations

C

Conrad Santiago

I was setting up a calulated total column in a Portfolio Analyzer view. I
entered an IF Statement and received an error.

Can you add logical statements to a calculated total calculation? Aside
from the basic arithmetic expressions (+,-,/,*), what other expressions can
you use here?

I searched the help file in MSP Pro and the SDK without success.

Thanks in advance for any answers.

Conrad Santiago
 
J

JackD

Try using an immediate if.
"iif" instead of "if"
You can also use a switch statement.
All the functions and operators are shown in the formula dialog box. Explore
it by going through all the pulldown menus and you will see what is
available.
 
M

Michael Steinberg

There is a wealth of functions you can use. See the Help for SQL Server
Analysis Services, which is located on the machine on which Analysis Services
is installed.
 
Top