In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Workflow formula

deriant12
6 - Meteoroid

Hello, 

Can someone tell me if I'm writing these formulas correctly in my workflow?  Any help is appreciated.  Thank you.

 

deriant12_0-1639933211648.png

NOL = IF [taxlosscf]>0 then 1
else 0
endif

 

ANOL= ([taxlosscf]-[lagtaxlosscf])/[lagassets] 

 

Haven= [TaxHaven]

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@deriant12 

 

IF [taxlosscf]>0 then 1
else 0
endif

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Emil_Kos
17 - Castor
17 - Castor

Hi @deriant12,

 

I think they are correct, but I would also check if the end results are valid.

deriant12
6 - Meteoroid

I think they are valid but my end results are off.  What about this one?

 

deriant12_0-1639937352694.png

 

LnAT= LOG10([lagassets])

MarqueeCrew
20 - Arcturus
20 - Arcturus

@deriant12 

 

LOG10(x): Returns the base-10 logarithm of (x).

Example

LOG10(1) returns 0.

LOG10(14) returns 1.146128.

 

So,

 

LOG10([lagassets])

 

should work as a double. 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors