Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
19 - Altair
19 - Altair

@deriant12 

 

IF [taxlosscf]>0 then 1
else 0
endif

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
Emil_Kos
16 - Nebula

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
19 - Altair
19 - Altair

@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 reboot. Order shall return.
Please Subscribe to my youTube channel.
Labels