I create measure with the following calculate:
sum(if($(V_SUM)=1,SALES,0)) / sum(COMP)
But the result is not correct.
The variable V_SUM define as following:
SET V_SUM ="if(TYPE = 'A – A',1,0)";
try with single quotes
sum(if('$(V_SUM)'=1,SALES,0)) / sum(COMP)
Thank you for your response
I have tried as you suggest but it didn't work ...
What does the variable V_SUM contain?
What do you mean by "not correct"? Is it returning a null value - not returning any value or is it just a wrong number?
Thank you for your response,
it's return number , but wrong number.
Can you please share the sample file to understand your data and we will give some ideas to over come this issue.
Retrieving data ...