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 

If i was able to help please mark my post which helped as solution.

Happy to help 🙂

Cheers and happy analyzing 😀