
1. Re: Parameter for Calculation
yogesh sawant Dec 26, 2016 12:28 AM (in response to Ben Hoa)Hello Ben,
You can try converting the field from measure to dimention and then use in the calculation.
Let me know if this doesnt resolve your issue.
Yogesh.

2. Re: Parameter for Calculation
Ashish Chaudhari Dec 26, 2016 12:57 AM (in response to Ben Hoa)Hi Ben,
is it possible to share the sample workbook here to know your case in detail and what is happening exactly.
if (avg(field1)  avg(field2) ) = 1 then avg({ include field3:sum(sales)}) else 0 end
Try using above formula. I have added avg function after then calculation. This is happening since in initial part you have used the avg() but in the function you didn't use any aggregation function (external). Thus it is giving the can't mix aggregate and nonaggregate values.
Thanks and Regards,
Ashish Chaudhari

3. Re: Parameter for Calculation
Chandra Bhaskar Jan 7, 2017 1:32 AM (in response to Ben Hoa)Hi Ben,,
Try with given formula it should be helpful for you..
{ include field3: if (avg(field1)  avg(field2) ) = 1 then sum(sales) else 0 end }
Bhaskar