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 2005 Forums  Analysis Server and Reporting Services (2005)  Named Calculations in Data Source Views

Author  Topic  ngk Starting Member 10 Posts Posted - 2008-09-03 : 08:14:39 Hi there, I'm currently creating a Report Builder model (my first one!) and need to know 1. Can I reference a Named Calc from another Named calc? e.g. if I have a Named Calc called Calc 1 how do I refer to it in this example of a Named Calc called Calc 2 : CASE (Calc 1) WHEN 0 THEN 0 ELSE Value_ToDate / Calc 1 END 2. How are these evaluated, i.e. is it a good idea or do I have to explicitly write the Calc 1 expression into Calc 2 - which would be a headache if it subsequently changes!