Workflow formula

[deriant12]

Hello, 

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

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

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

Haven= [TaxHaven]

[MarqueeCrew · Accepted solution]

@deriant12 

IF [taxlosscf]>0 then 1
else 0
endif

[Emil_Kos]

Hi @deriant12,

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

[deriant12]

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

LnAT= LOG10([lagassets])

[MarqueeCrew · Accepted solution]

@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