Forum Discussion

sgannon1's avatar
sgannon1
Frequent Visitor
10 years ago
Solved

'Token then expected' error

Hi all,    Can anybody please tell me what 'token then expected' error means? I have created the below formula (I am trying to allocated fiscal year to each month), but obviously I am doing someth...
Need Help
kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago

This is referring to the proper set up of the if statement. It is not like excel. It needs a 'then' and and 'else' instead of commas.

It should be:

=if [Month]>9 then [year] + 1 else [year]

If in PQL follws this format:

= if <Logical_test> then <result> else <alternate_result>

Anonymous's avatar
Anonymous
Not applicable
7 years ago

kcantor  or smpa01 See below If then error for custom column. It is only erroring out the first then- please advise how to fix this formula. thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I figured it out nevermind. Once I removed all the ) before each of the thens the formula was accepted. Wish the error highlighted the ) parenthesis --calling it a token Then error is misleading bc the then is already there.