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
If i was able to help please mark my post which helped as solution.
Happy to help 🙂
Cheers and happy analyzing 😀