Skip to main content
Nintex Community Menu Bar
Question

Cant figure out IF statement syntax error

  • July 11, 2024
  • 2 replies
  • 2 views
  • Translate

Forum|alt.badge.img+8

Hello,

I have a nested IF statement shown below that seems to have correct logic yet I am getting an odd error.

Formula used in the UI-Only field:

IF({{NRR}} <= 100, ({{OriginalBook}}-{{BookWon}})*0.0025, IF({{NRR}} > 100 &amp;&amp; <= 120, {{OriginalBook}}*0.0025 + ({{BookWon}}-{{OriginalBook}})*0.0075, {{OriginalBook}}*0.0025 + ({{OriginalBook}}*0.25)*0.0075 + ({{BookWon}}-({{OriginalBook}}*1.25))*0.015))

Error:

SyntaxError: Expected "'", "(", ".", """", "date", "false", "null", "true", "undefined", [ x0C

	x0B    -      ], [0-9], [-+!], or [a-z] but "<" found. 

{{NRR}} is another formula field returning a number.

Did this topic help you find an answer to your question?

Forum|alt.badge.img+20

IF({{NRR}} > 100 && <= 120 This looks like it’s missing the {{NRR}} after &&

Translate

Forum|alt.badge.img+8

wow beautiful, thank you. Can’t believe I missed that

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings