Solved: Getting Token Eof Expected

Anonymous · ‎06-09-2021

[Pay Structure]="Net" then [#"Closed Premium "]*[#"Commission %"] else [#"Closed Premium "]*[#"Commission %"]+[Escrow Fee]

Anonymous · ‎06-09-2021

Try:

if [Pay Structure]="Net" then ([Closed Premium]*[Commission %]) else ([Closed Premium]*[Commission %])+[Escrow Fee]

You don't have to qualify special characters when referring to a [Column]. If you really do have a space at the end of [Closed Premium] as you do above, you'll have to include that or just remove it.

--Nate

View solution in original post

Anonymous · ‎06-09-2021

Try:

if [Pay Structure]="Net" then ([Closed Premium]*[Commission %]) else ([Closed Premium]*[Commission %])+[Escrow Fee]

You don't have to qualify special characters when referring to a [Column]. If you really do have a space at the end of [Closed Premium] as you do above, you'll have to include that or just remove it.

--Nate