Retrieving last non-zero value
I created a module with exchange rates data for each month. Then, I put summary as : sum, time: closing balance.
But as I only have data until Sep 2020, it puts 0 for FY20 and 21. So, I would like to set up a formula that retrieve the last non-zero value for FY20 and FY21 for instance.
Thank you for your help!