lobocheese
Programmer
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!
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!