IF Condition

[dseelam]

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

[Arthur_Fong · Accepted solution]

Did you notice that the error is actually coming from double commas?

[Brett_Bleess]

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