Forum Discussion
Getting Token Eof Expected
[Pay Structure]="Net" then [#"Closed Premium "]*[#"Commission %"] else [#"Closed Premium "]*[#"Commission %"]+[Escrow Fee]
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
1 Reply
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