
1. Re: Calculation keeping one parameter constant
Ivan Young Oct 19, 2016 4:54 PM (in response to Jatin Kakani)Try putting your LOD inside a SUM, SUM([My LOD]). This may solve your aggregate nonaggregate error.

2. Re: Calculation keeping one parameter constant
Jatin Kakani Oct 19, 2016 5:00 PM (in response to Ivan Young)1 of 1 people found this helpfulHi Ivan,
Thank you for your reply.
I tried using SUM, however I am not able to achieve what I want.
I am not sure if I am using the LOD expression in a right way.
Below is the LOD expression I am trying to use:
COUNTD([Completed])
/
(
SUM({FIXED [Product Desc]:COUNTD([Completed])})
+
SUM({FIXED [Product Desc]:COUNTD([Terminated or Scrapped])})
)
Regards,
Jatin

3. Re: Calculation keeping one parameter constant
Ivan Young Oct 19, 2016 5:06 PM (in response to Jatin Kakani)1 of 1 people found this helpfulHi Jatin,
What does it give you and how does it differ from what you want?
Have you tried?
COUNTD([Completed])
/
SUM (
({FIXED [Product Desc]:COUNTD([Completed])})
+
({FIXED [Product Desc]:COUNTD([Terminated or Scrapped])})
)

4. Re: Calculation keeping one parameter constant
Jatin Kakani Oct 19, 2016 5:14 PM (in response to Ivan Young)Hi Ivan,
I just tried the expression you have given.
However, it gives me the same results as it would have given without using the FIXED clause.
So basically, for each product category it first filters out the lots for that particular product and then performs the calculation.
So my requirement of just varying the numerator for each product category keeping the denominator always constant is not being met.
Regards,
Jatin