Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I create measure with the following calculate:
sum(if($(V_SUM)=1,SALES,0)) / sum(COMP)
But the result is not correct.
Any Idea?
Thank you.
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)
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
I have tried as you suggest but it didn't work ...
Hi,
Thank you for your response,
The variable V_SUM define as following:
SET V_SUM ="if(TYPE = 'A – A',1,0)";
it's return number , but wrong number.
Hi Ruti,
Can you please share the sample file to understand your data and we will give some ideas to over come this issue.
Regards
Sathish