Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following script error when reloading from one line reading "Error in expression: it takes 2-3 parameters."
Here's the scripting:
Here's what ConcatKey =:
I would be easier to reply if yoour script was text and not a picture.
You have 2 IFs at the end of the expression. They say something like:
if(IsNum(ItemID))
Those IFs have only 1 parameter.
I don't know how to get rid of them based on the scripting. Any idea?
Load error:
if(trim('01')='' or IsNull('01'), '*NONE', trim('01')) & '%' & if(trim(If(IsNum(ItemID))='' or IsNull(If(IsNum(ItemID)), '*NONE', trim(If(IsNum(ItemID))) as _ItemID,
Scripting:
$(ConcatKey('$(varCompanyID)', If(IsNum(ItemID), Num(ItemID,'##########"), ItemID))) as _ItemID,
ConcatKey:
ConcatKey = if(trim($1)='' or IsNull($1), '*NONE', trim($1)) & '%' & if(trim($2)='' or IsNull($2), '*NONE', trim($2));