This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm creating a formula where my posting period is between 1-9 then I want it to be given a leading 0. I have created the following formula but I am getting the error "Invalid type in operator >="
Can someone help me fix the below formula? Thank you
IF [Posting Period]>=1 AND [Posting Period]<=9
THEN "0"+[Posting Period]
ELSE [Posting Period]
ENDIF
Solved! Go to Solution.
The Invalid operator is due to trying to find a numeric calculation on a String. You can use the ToNumber() function to help with this.
IF tonumber([Posting Period])>=1 AND tonumber([Posting Period])<=9
THEN "0"+[Posting Period]
ELSE [Posting Period]
ENDIF
See attached.
Hey @AustinBauer
Your [Posting Period] is a string...so wrap the first part in ToNumber()
So if ToNumber([Posting Period]) >= 1 AND toNumber([Posting Period])<=9 etc...