Formula Tool

[hii_amit]

I am new to Aletryx

i have used the formula so far like this to populate Sep, Oct, Nov and Dec

if [Final Status]="In Seat" then [July]-([July]*[Voluntary Attrition]) else [Sep] endif

i don't want to use use Voluntary attrition % in calculation where Group Data will result in negative number by Dec as highlighted in RED for VP grade in the below screen shot, it should populate what is there in July for consecutive months

[atcodedog05]

Hi @hii_amit 

Here is the workflow

As mentioned i am only doing modification on rows where month is negative and then adding them back.

As a result negative removed.

Hope this helps 🙂

[hii_amit]

i am getting 0 when i use the formula as per the screenshot below

can u suggest if this has anything to do with datatype error or something else

[atcodedog05]

Hi @hii_amit 

Use only [july] in formula. [Sep]=[July] becomes a condition. Since Sep is not equal to July its returning False(0)

Hope this helps 🙂

[hii_amit]

Thanks mate your help was really helpful

Now i realised power of Alteryx community

will definitely use it more frequently

[atcodedog05]

Hi @hii_amit 

Glad to hear it helped 🙂

If this post helps you please mark it as solution. Please dont forget.

And give a like if you dont mind 😀👍

[StephV]

Hi @hii_amit, 

Thank you for your question to the Community! Glad to see that @atcodedog05 could help you! You're right our Alteryx Community is very powerful!

Can you please mark it as solution, it will help other users. 

I just moved your post to the Designer Discussions forum, there you can ask anything technical about Designer. 

This article "Q&A: Where Do I Post My Questions?" should also help you out. 

Let us know how it goes!

Cheers,

[hii_amit]

Hi,

Is it possible i can call data from other tool in the same workflow

i don't want to call July for each month, i have data grouped in same workflow and tool name is filter (99),

want to call it from there 

[atcodedog05 · Accepted solution]

Hi @hii_amit ,

No you cant. But you use Join on key to only Julys data at specific part.

Hope this helps 🙂

[FláviaB · Accepted solution]

Thank you for all your help @atcodedog05! 

@hii_amit I am moving this post to our Designer Discussions board so it has more visibility and it can also help other users with the same questions. 😉

[hii_amit]

this resolved my query

thanks