Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Folks,
I have 2 expression some thing like below
if(isnull(OldPrize),(sum(GROSS_SALES)/sum(SHIPPED_QUANTITY)),OldPrize)---Old Gross Price / Unit - this is working fine
if(isnull(AdjSale),(sum([Adj Sales])/sum(SHIPPED_QUANTITY)),AdjSale)----Old Adj Sales/Unit- Not Working
the only diff I see in both expressions GROSS_SALES vs [Adj Sales], GROSS_SALES is coming from data, [Adj Sales] is an other expression contains multiple other expressions.
[Adj Sales] defined as: [Gross Sales] - (Royalties + [PA - Acc] + [PA - UnAcc] + [Unplanned Allowances])
which is
when I elaborate it is throwing error in expression please help me to write this in proper format?
Tanks,
D
Did you notice that the error is actually coming from double commas?
D, did Arthur's post catch the issue? If so, please do not forget to use the Accept as Solution button on his post to mark that as the solution and give him credit.
Regards,
Brett