Last Non-Zero Occurrence

Options
Vicky_Kapri
Vicky_Kapri Member, ALL USERS, Partner, Certified Model Builder Posts: 3 New Contributor

There is a requirement where in module 1(Pic 1), there are some transactions and users wants the Last Non-Zero occurrence in Module 2. How we can get the Last Non-Zero data in module 2(Pic 2)? Highlighted are the numbers that we want in module 2.

 

Module 1

Vicky_Kapri_2-1610904100437.png

 

Module 2

Vicky_Kapri_0-1610904056043.png