Using Var in Column expressions with Join Function

[Felipereis50]

Hi Friends

It’s possible to use Var like this?
How to manage this code?
The way I did it doesn’t work

var alq = if (column("ICMS")>0) {column("ICMS")} else column("ICMS_ST");
joinSep("|","0200",column("cProd"),column("xProd"),column("cEAN"),"PC",column("NCM"),alq,column("CEST"))

@AlexanderFillbrunn
Do you know?

Cheers friend.

[AlexanderFillbrunn]

Hi,
You can, but the way you create the variable does not work. An if cannot be used like an expression. You have to do:

var alq = column("ICMS_ST");
if(...) {
    alq = column("ICMS");
}

Kind regards,
Alexander

[Felipereis50]

Thanks my friend
It worked