Custom Column - Syntax - Token EOF expected

[SWebber]

Hi 

I am new to PowerBI please could I ask for assistance with the formula for a custom column.

I have two calculated columns :

[Target Incident TTR min] - Whole number custom column (converted milliseconds to minutes)

[Incident TTR min] - Whole number custom column (converted milliseconds to minutes)

I want a new column using these two fields :
This is my formula :
IF [Incident TTR min]>0 then [Incident TTR min] else (-1*[Incident TTR min]) + [Target Incident TTR min]

I am getting Token Eof expected. Not sure why.

[HotChilli]

I hope you've found the solution now.  Start by making the 'IF' lower case -> 'if'