Calculated Cells

#1

I have a column called total amount in the Cube and I want it to be (-1) * total amount. But when I type (-1) * total amount in the Calculated Cells I get #Err. I don't the reasons for it
Please help me out and let me know if you have the solution for this

Thanks

#2

Try this:

- (calculationpassvalue( [total amount], -1))

public @ the domain below
www.tomchester.net

"Png" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a column called total amount in the Cube and I want it to be (-1) *
total amount. But when I type (-1) * total amount in the Calculated Cells I

get #Err. I don't the reasons for it;

Quote:

Please help me out and let me know if you have the solution for this.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Calculated Cells

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Calculated Cells - 02-19-2004 , 08:21 AM

Re: Calculated Cells - 02-19-2004 , 09:36 AM