need to apply formula to each field as per numeric value

[AdityaGuptaToyoEng]

PLEASE HELP.  GOT A CERTAIN FORMULA FOR DATA IN 5-6 COLUMNS ALL NUMERIC  . NOW BASED ON NUMERIC VALUE, NEED TO APPLY DIFFERENT MARGIN

[Luke_C]

Hi @AdityaGuptaToyoEng 

Just looking at it there are a few syntax errors in the formula (extra parenthesis, etc). The error in your screenshot is because of this piece of the formula: Round([_CurrentField_)*1.2,10))  The red parenthesis is actually ending the round function, which is unexpected for Alteryx. 

Try this and let me know if it works, otherwise please accept the solution!

if [_CurrentField_]<=600000 then Round([_CurrentField_]*1.2,10)



elseif [_CurrentField_]>600000 and [_CurrentField_]<1200000 then Round([_CurrentField_]*1.1,10)



else null() // You need an else clause here, I put null but replace with something suitable for you.


endif