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
Solved! Go to Solution.
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 🙂
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
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 🙂
Thanks mate your help was really helpful
Now i realised power of Alteryx community
will definitely use it more frequently
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 😀👍
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,
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
Hi @hii_amit ,
No you cant. But you use Join on key to only Julys data at specific part.
Hope this helps 🙂
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. 😉
this resolved my query
thanks