Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Newbie: arithmetic operation using a total in a fo

Author  Topic  zang Starting Member 14 Posts Posted - 2009-08-11 : 09:04:39 Hi, I’m quite newbie on this. I need to use the total of sales in a formula, How can I do that? I need to make the Sales_Percent Formula. Cube Example Products Sales ? Sales_Percent Product A 10 (10/42)*100 = 23.8 Product B 20 (20/42)*100 = 47.6 Procuct C 12 (12/42)*100 = 28.57 Total 42 Sales is a variable but the Total Sales is just a total of Sales Variable. The formula should be something like (Sales/TotalSales) How can I build the Sales_Percent Formula in the Cube? What is the proper command to obtain totalsales? The two questions are appointing to the same thing. Hope to be clear Regards Ariel