token then expected

Hi sks2701 

It must be the % character. You can't use it like that. Instead of 1% use the number: 1/100 or  0.01. Same for all other % instances in the code

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Hi sks2701 

Make sure to replace all % values where you are representing a number e.g.

if [Net sales growth] < 0.01
else if [Net sales growth] >= 0.26

 etc.

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.